3154: IF l_template_id IS NOT NULL THEN
3155: x_template_name := l_tmpl_name;
3156: x_template_description := l_template_desc;
3157: ELSE
3158: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3159: x_template_name:= fnd_message.get;
3160: x_template_description := NULL;
3161: END IF;
3162: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3155: x_template_name := l_tmpl_name;
3156: x_template_description := l_template_desc;
3157: ELSE
3158: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3159: x_template_name:= fnd_message.get;
3160: x_template_description := NULL;
3161: END IF;
3162: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3163: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'16200: Return success Get_Contract_Details');
3165: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'16400: x_contract_source:'||x_contract_source);
3166: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'16500: x_template_name:'||x_template_name);
3167: END IF;
3168: ELSE
3169: fnd_message.set_name('OKC','OKC_TERMS_AUTH_PARTY_NONE');
3170: x_authoring_party := fnd_message.get;
3171: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3172: x_contract_source := fnd_message.get;
3173: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3166: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'16500: x_template_name:'||x_template_name);
3167: END IF;
3168: ELSE
3169: fnd_message.set_name('OKC','OKC_TERMS_AUTH_PARTY_NONE');
3170: x_authoring_party := fnd_message.get;
3171: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3172: x_contract_source := fnd_message.get;
3173: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3174: x_template_name:= fnd_message.get;
3167: END IF;
3168: ELSE
3169: fnd_message.set_name('OKC','OKC_TERMS_AUTH_PARTY_NONE');
3170: x_authoring_party := fnd_message.get;
3171: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3172: x_contract_source := fnd_message.get;
3173: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3174: x_template_name:= fnd_message.get;
3175: x_template_description := NULL;
3168: ELSE
3169: fnd_message.set_name('OKC','OKC_TERMS_AUTH_PARTY_NONE');
3170: x_authoring_party := fnd_message.get;
3171: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3172: x_contract_source := fnd_message.get;
3173: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3174: x_template_name:= fnd_message.get;
3175: x_template_description := NULL;
3176: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3169: fnd_message.set_name('OKC','OKC_TERMS_AUTH_PARTY_NONE');
3170: x_authoring_party := fnd_message.get;
3171: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3172: x_contract_source := fnd_message.get;
3173: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3174: x_template_name:= fnd_message.get;
3175: x_template_description := NULL;
3176: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3177: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'16600: Return Get_Contract_Details,no terms exist');
3170: x_authoring_party := fnd_message.get;
3171: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3172: x_contract_source := fnd_message.get;
3173: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3174: x_template_name:= fnd_message.get;
3175: x_template_description := NULL;
3176: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3177: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'16600: Return Get_Contract_Details,no terms exist');
3178: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'16700: x_authoring_party:'||x_authoring_party);
3426: x_template_name := l_tmpl_name;
3427: x_template_description := l_template_desc;
3428: x_template_instruction := l_instruction;
3429: ELSE
3430: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3431: x_template_name:= fnd_message.get;
3432: x_template_description := NULL;
3433: x_template_instruction := NULL;
3434: END IF;
3427: x_template_description := l_template_desc;
3428: x_template_instruction := l_instruction;
3429: ELSE
3430: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3431: x_template_name:= fnd_message.get;
3432: x_template_description := NULL;
3433: x_template_instruction := NULL;
3434: END IF;
3435: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3439: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'16500: x_template_name:'||x_template_name);
3440: END IF;
3441:
3442: ELSE
3443: fnd_message.set_name('OKC','OKC_TERMS_AUTH_PARTY_NONE');
3444: x_authoring_party := fnd_message.get;
3445: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3446: x_contract_source := fnd_message.get;
3447: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3440: END IF;
3441:
3442: ELSE
3443: fnd_message.set_name('OKC','OKC_TERMS_AUTH_PARTY_NONE');
3444: x_authoring_party := fnd_message.get;
3445: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3446: x_contract_source := fnd_message.get;
3447: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3448: x_template_name:= fnd_message.get;
3441:
3442: ELSE
3443: fnd_message.set_name('OKC','OKC_TERMS_AUTH_PARTY_NONE');
3444: x_authoring_party := fnd_message.get;
3445: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3446: x_contract_source := fnd_message.get;
3447: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3448: x_template_name:= fnd_message.get;
3449: x_template_description := NULL;
3442: ELSE
3443: fnd_message.set_name('OKC','OKC_TERMS_AUTH_PARTY_NONE');
3444: x_authoring_party := fnd_message.get;
3445: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3446: x_contract_source := fnd_message.get;
3447: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3448: x_template_name:= fnd_message.get;
3449: x_template_description := NULL;
3450: x_template_instruction := NULL;
3443: fnd_message.set_name('OKC','OKC_TERMS_AUTH_PARTY_NONE');
3444: x_authoring_party := fnd_message.get;
3445: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3446: x_contract_source := fnd_message.get;
3447: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3448: x_template_name:= fnd_message.get;
3449: x_template_description := NULL;
3450: x_template_instruction := NULL;
3451: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3444: x_authoring_party := fnd_message.get;
3445: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3446: x_contract_source := fnd_message.get;
3447: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3448: x_template_name:= fnd_message.get;
3449: x_template_description := NULL;
3450: x_template_instruction := NULL;
3451: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3452: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'16600: Return Get_Contract_Details,no terms exist');
3720: IF p_template_id IS NOT NULL THEN
3721: OPEN terms_tmpl_csr;
3722: FETCH terms_tmpl_csr INTO x_template_name,x_template_description,x_contract_source,x_authoring_party;
3723: IF terms_tmpl_csr%NOTFOUND THEN
3724: fnd_message.set_name('OKC','OKC_TERMS_AUTH_PARTY_NONE');
3725: x_authoring_party := fnd_message.get;
3726: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3727: x_contract_source := fnd_message.get;
3728: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3721: OPEN terms_tmpl_csr;
3722: FETCH terms_tmpl_csr INTO x_template_name,x_template_description,x_contract_source,x_authoring_party;
3723: IF terms_tmpl_csr%NOTFOUND THEN
3724: fnd_message.set_name('OKC','OKC_TERMS_AUTH_PARTY_NONE');
3725: x_authoring_party := fnd_message.get;
3726: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3727: x_contract_source := fnd_message.get;
3728: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3729: x_template_name:= fnd_message.get;
3722: FETCH terms_tmpl_csr INTO x_template_name,x_template_description,x_contract_source,x_authoring_party;
3723: IF terms_tmpl_csr%NOTFOUND THEN
3724: fnd_message.set_name('OKC','OKC_TERMS_AUTH_PARTY_NONE');
3725: x_authoring_party := fnd_message.get;
3726: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3727: x_contract_source := fnd_message.get;
3728: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3729: x_template_name:= fnd_message.get;
3730: x_template_description := NULL;
3723: IF terms_tmpl_csr%NOTFOUND THEN
3724: fnd_message.set_name('OKC','OKC_TERMS_AUTH_PARTY_NONE');
3725: x_authoring_party := fnd_message.get;
3726: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3727: x_contract_source := fnd_message.get;
3728: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3729: x_template_name:= fnd_message.get;
3730: x_template_description := NULL;
3731: END IF;
3724: fnd_message.set_name('OKC','OKC_TERMS_AUTH_PARTY_NONE');
3725: x_authoring_party := fnd_message.get;
3726: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3727: x_contract_source := fnd_message.get;
3728: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3729: x_template_name:= fnd_message.get;
3730: x_template_description := NULL;
3731: END IF;
3732: CLOSE terms_tmpl_csr;
3725: x_authoring_party := fnd_message.get;
3726: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3727: x_contract_source := fnd_message.get;
3728: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3729: x_template_name:= fnd_message.get;
3730: x_template_description := NULL;
3731: END IF;
3732: CLOSE terms_tmpl_csr;
3733:
3731: END IF;
3732: CLOSE terms_tmpl_csr;
3733:
3734: ELSE
3735: fnd_message.set_name('OKC','OKC_TERMS_AUTH_PARTY_NONE');
3736: x_authoring_party := fnd_message.get;
3737: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3738: x_contract_source := fnd_message.get;
3739: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3732: CLOSE terms_tmpl_csr;
3733:
3734: ELSE
3735: fnd_message.set_name('OKC','OKC_TERMS_AUTH_PARTY_NONE');
3736: x_authoring_party := fnd_message.get;
3737: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3738: x_contract_source := fnd_message.get;
3739: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3740: x_template_name:= fnd_message.get;
3733:
3734: ELSE
3735: fnd_message.set_name('OKC','OKC_TERMS_AUTH_PARTY_NONE');
3736: x_authoring_party := fnd_message.get;
3737: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3738: x_contract_source := fnd_message.get;
3739: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3740: x_template_name:= fnd_message.get;
3741: x_template_description := NULL;
3734: ELSE
3735: fnd_message.set_name('OKC','OKC_TERMS_AUTH_PARTY_NONE');
3736: x_authoring_party := fnd_message.get;
3737: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3738: x_contract_source := fnd_message.get;
3739: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3740: x_template_name:= fnd_message.get;
3741: x_template_description := NULL;
3742: END IF;
3735: fnd_message.set_name('OKC','OKC_TERMS_AUTH_PARTY_NONE');
3736: x_authoring_party := fnd_message.get;
3737: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3738: x_contract_source := fnd_message.get;
3739: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3740: x_template_name:= fnd_message.get;
3741: x_template_description := NULL;
3742: END IF;
3743:
3736: x_authoring_party := fnd_message.get;
3737: fnd_message.set_name('OKC','OKC_TERMS_CONTRACT_SOURCE_NONE');
3738: x_contract_source := fnd_message.get;
3739: fnd_message.set_name('OKC','OKC_TERMS_TEMPLATE_NAME_NONE');
3740: x_template_name:= fnd_message.get;
3741: x_template_description := NULL;
3742: END IF;
3743:
3744: -- Standard call to get message count and if count is 1, get message info.