eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_REP_UTIL_PVT dependencies on FND_MESSAGE

Line 3094: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_DOC_NAME');

3090: END IF;
3091: IF (l_valid_flag = 'Y' AND (l_import_documents_rec.FILE_NAME IS NULL OR LENGTH(l_import_documents_rec.FILE_NAME)=0)) THEN
3092: l_valid_flag := 'N';
3093:
3094: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_DOC_NAME');
3095: fnd_message.set_token(TOKEN => 'DOC_INDEX',
3096: VALUE => l_import_documents_rec.document_index);
3097: l_error_msg := fnd_message.get;
3098: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3095: fnd_message.set_token(TOKEN => 'DOC_INDEX',

3091: IF (l_valid_flag = 'Y' AND (l_import_documents_rec.FILE_NAME IS NULL OR LENGTH(l_import_documents_rec.FILE_NAME)=0)) THEN
3092: l_valid_flag := 'N';
3093:
3094: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_DOC_NAME');
3095: fnd_message.set_token(TOKEN => 'DOC_INDEX',
3096: VALUE => l_import_documents_rec.document_index);
3097: l_error_msg := fnd_message.get;
3098: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3099: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3097: l_error_msg := fnd_message.get;

3093:
3094: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_DOC_NAME');
3095: fnd_message.set_token(TOKEN => 'DOC_INDEX',
3096: VALUE => l_import_documents_rec.document_index);
3097: l_error_msg := fnd_message.get;
3098: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3099: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3100: 'Document Name is missing');
3101: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3122: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_LONG_DOC_NAME');

3118: --File Name should be <= 256
3119: IF (l_valid_flag = 'Y' AND LENGTH(l_import_documents_rec.file_name) > l_file_name_length) THEN
3120: l_valid_flag := 'N';
3121:
3122: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_LONG_DOC_NAME');
3123: fnd_message.set_token(TOKEN => 'DOC_INDEX',
3124: VALUE => l_import_documents_rec.document_index);
3125: l_error_msg := fnd_message.get;
3126: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3123: fnd_message.set_token(TOKEN => 'DOC_INDEX',

3119: IF (l_valid_flag = 'Y' AND LENGTH(l_import_documents_rec.file_name) > l_file_name_length) THEN
3120: l_valid_flag := 'N';
3121:
3122: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_LONG_DOC_NAME');
3123: fnd_message.set_token(TOKEN => 'DOC_INDEX',
3124: VALUE => l_import_documents_rec.document_index);
3125: l_error_msg := fnd_message.get;
3126: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3127: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3125: l_error_msg := fnd_message.get;

3121:
3122: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_LONG_DOC_NAME');
3123: fnd_message.set_token(TOKEN => 'DOC_INDEX',
3124: VALUE => l_import_documents_rec.document_index);
3125: l_error_msg := fnd_message.get;
3126: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3127: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3128: 'Document Name is too long');
3129: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3147: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_LONG_DOC_DESC');

3143: --File Name should be <= 256
3144: IF (l_valid_flag = 'Y' AND l_import_documents_rec.document_desc IS NOT NULL AND LENGTH(l_import_documents_rec.document_desc) > l_file_desc_length) THEN
3145: l_valid_flag := 'N';
3146:
3147: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_LONG_DOC_DESC');
3148: fnd_message.set_token(TOKEN => 'DOC_INDEX',
3149: VALUE => l_import_documents_rec.document_index);
3150: l_error_msg := fnd_message.get;
3151: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3148: fnd_message.set_token(TOKEN => 'DOC_INDEX',

3144: IF (l_valid_flag = 'Y' AND l_import_documents_rec.document_desc IS NOT NULL AND LENGTH(l_import_documents_rec.document_desc) > l_file_desc_length) THEN
3145: l_valid_flag := 'N';
3146:
3147: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_LONG_DOC_DESC');
3148: fnd_message.set_token(TOKEN => 'DOC_INDEX',
3149: VALUE => l_import_documents_rec.document_index);
3150: l_error_msg := fnd_message.get;
3151: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3152: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3150: l_error_msg := fnd_message.get;

3146:
3147: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_LONG_DOC_DESC');
3148: fnd_message.set_token(TOKEN => 'DOC_INDEX',
3149: VALUE => l_import_documents_rec.document_index);
3150: l_error_msg := fnd_message.get;
3151: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3152: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3153: 'Document Description is too long');
3154: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3178: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_DOC_CATEGORY');

3174: IF (l_valid_flag = 'Y' AND (l_import_documents_rec.category_name_txt IS NULL OR LENGTH(l_import_documents_rec.category_name_txt)=0)) THEN
3175: l_valid_flag := 'N';
3176: l_category_code := NULL;
3177:
3178: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_DOC_CATEGORY');
3179: fnd_message.set_token(TOKEN => 'DOC_INDEX',
3180: VALUE => l_import_documents_rec.document_index);
3181: l_error_msg := fnd_message.get;
3182: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3179: fnd_message.set_token(TOKEN => 'DOC_INDEX',

3175: l_valid_flag := 'N';
3176: l_category_code := NULL;
3177:
3178: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_DOC_CATEGORY');
3179: fnd_message.set_token(TOKEN => 'DOC_INDEX',
3180: VALUE => l_import_documents_rec.document_index);
3181: l_error_msg := fnd_message.get;
3182: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3183: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3181: l_error_msg := fnd_message.get;

3177:
3178: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_DOC_CATEGORY');
3179: fnd_message.set_token(TOKEN => 'DOC_INDEX',
3180: VALUE => l_import_documents_rec.document_index);
3181: l_error_msg := fnd_message.get;
3182: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3183: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3184: 'Document Category is missing');
3185: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3208: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_DOC_CATEGORY');

3204: IF document_category_csr%NOTFOUND THEN
3205: l_valid_flag := 'N';
3206: l_category_code := NULL;
3207:
3208: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_DOC_CATEGORY');
3209: fnd_message.set_token(TOKEN => 'DOC_INDEX',
3210: VALUE => l_import_documents_rec.document_index);
3211: l_error_msg := fnd_message.get;
3212: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3209: fnd_message.set_token(TOKEN => 'DOC_INDEX',

3205: l_valid_flag := 'N';
3206: l_category_code := NULL;
3207:
3208: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_DOC_CATEGORY');
3209: fnd_message.set_token(TOKEN => 'DOC_INDEX',
3210: VALUE => l_import_documents_rec.document_index);
3211: l_error_msg := fnd_message.get;
3212: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3213: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3211: l_error_msg := fnd_message.get;

3207:
3208: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_DOC_CATEGORY');
3209: fnd_message.set_token(TOKEN => 'DOC_INDEX',
3210: VALUE => l_import_documents_rec.document_index);
3211: l_error_msg := fnd_message.get;
3212: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3213: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3214: 'Category ID not found with given category name: '||l_import_documents_rec.category_name_txt);
3215: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3465: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_NAME');

3461: END IF;
3462: IF (l_valid_flag = 'Y' AND (l_import_parties_rec.party_name_txt IS NULL OR LENGTH(l_import_parties_rec.party_name_txt)=0)) THEN
3463: l_valid_flag := 'N';
3464:
3465: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_NAME');
3466: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3467: VALUE => l_import_parties_rec.party_index);
3468: l_error_msg := fnd_message.get;
3469: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3466: fnd_message.set_token(TOKEN => 'PARTY_INDEX',

3462: IF (l_valid_flag = 'Y' AND (l_import_parties_rec.party_name_txt IS NULL OR LENGTH(l_import_parties_rec.party_name_txt)=0)) THEN
3463: l_valid_flag := 'N';
3464:
3465: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_NAME');
3466: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3467: VALUE => l_import_parties_rec.party_index);
3468: l_error_msg := fnd_message.get;
3469: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3470: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3468: l_error_msg := fnd_message.get;

3464:
3465: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_NAME');
3466: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3467: VALUE => l_import_parties_rec.party_index);
3468: l_error_msg := fnd_message.get;
3469: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3470: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3471: 'Party Name is missing');
3472: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3494: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_ROLE');

3490: END IF;
3491: IF (l_valid_flag = 'Y' AND (l_import_parties_rec.party_role_txt IS NULL OR LENGTH(l_import_parties_rec.party_role_txt)=0)) THEN
3492: l_valid_flag := 'N';
3493:
3494: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_ROLE');
3495: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3496: VALUE => l_import_parties_rec.party_index);
3497: l_error_msg := fnd_message.get;
3498: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3495: fnd_message.set_token(TOKEN => 'PARTY_INDEX',

3491: IF (l_valid_flag = 'Y' AND (l_import_parties_rec.party_role_txt IS NULL OR LENGTH(l_import_parties_rec.party_role_txt)=0)) THEN
3492: l_valid_flag := 'N';
3493:
3494: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_ROLE');
3495: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3496: VALUE => l_import_parties_rec.party_index);
3497: l_error_msg := fnd_message.get;
3498: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3499: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3497: l_error_msg := fnd_message.get;

3493:
3494: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_ROLE');
3495: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3496: VALUE => l_import_parties_rec.party_index);
3497: l_error_msg := fnd_message.get;
3498: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3499: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3500: 'Party Role is missing');
3501: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3530: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_SIGNED_BY');

3526: END IF;
3527: IF (l_valid_flag = 'Y' AND (l_import_parties_rec.signed_by_txt IS NULL OR LENGTH(l_import_parties_rec.signed_by_txt)=0)) THEN
3528: l_valid_flag := 'N';
3529:
3530: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_SIGNED_BY');
3531: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3532: VALUE => l_import_parties_rec.party_index);
3533: l_error_msg := fnd_message.get;
3534: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3531: fnd_message.set_token(TOKEN => 'PARTY_INDEX',

3527: IF (l_valid_flag = 'Y' AND (l_import_parties_rec.signed_by_txt IS NULL OR LENGTH(l_import_parties_rec.signed_by_txt)=0)) THEN
3528: l_valid_flag := 'N';
3529:
3530: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_SIGNED_BY');
3531: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3532: VALUE => l_import_parties_rec.party_index);
3533: l_error_msg := fnd_message.get;
3534: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3535: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3533: l_error_msg := fnd_message.get;

3529:
3530: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_SIGNED_BY');
3531: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3532: VALUE => l_import_parties_rec.party_index);
3533: l_error_msg := fnd_message.get;
3534: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3535: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3536: 'Party Signed By is missing');
3537: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3557: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_LONG_SIGNED_BY');

3553: IF (l_valid_flag = 'Y' AND l_import_parties_rec.signed_by_txt IS NOT NULL
3554: AND LENGTH(l_import_parties_rec.signed_by_txt) > l_signed_by_length) THEN
3555: l_valid_flag := 'N';
3556:
3557: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_LONG_SIGNED_BY');
3558: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3559: VALUE => l_import_parties_rec.party_index);
3560: l_error_msg := fnd_message.get;
3561: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3558: fnd_message.set_token(TOKEN => 'PARTY_INDEX',

3554: AND LENGTH(l_import_parties_rec.signed_by_txt) > l_signed_by_length) THEN
3555: l_valid_flag := 'N';
3556:
3557: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_LONG_SIGNED_BY');
3558: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3559: VALUE => l_import_parties_rec.party_index);
3560: l_error_msg := fnd_message.get;
3561: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3562: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3560: l_error_msg := fnd_message.get;

3556:
3557: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_LONG_SIGNED_BY');
3558: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3559: VALUE => l_import_parties_rec.party_index);
3560: l_error_msg := fnd_message.get;
3561: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3562: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3563: 'Party Signed By is too long');
3564: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3587: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_SIGNED_DATE');

3583: END IF;
3584: IF (l_valid_flag = 'Y' AND (l_import_parties_rec.signed_date IS NULL OR LENGTH(l_import_parties_rec.signed_date)=0)) THEN
3585: l_valid_flag := 'N';
3586:
3587: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_SIGNED_DATE');
3588: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3589: VALUE => l_import_parties_rec.party_index);
3590: l_error_msg := fnd_message.get;
3591: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3588: fnd_message.set_token(TOKEN => 'PARTY_INDEX',

3584: IF (l_valid_flag = 'Y' AND (l_import_parties_rec.signed_date IS NULL OR LENGTH(l_import_parties_rec.signed_date)=0)) THEN
3585: l_valid_flag := 'N';
3586:
3587: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_SIGNED_DATE');
3588: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3589: VALUE => l_import_parties_rec.party_index);
3590: l_error_msg := fnd_message.get;
3591: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3592: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3590: l_error_msg := fnd_message.get;

3586:
3587: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_SIGNED_DATE');
3588: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3589: VALUE => l_import_parties_rec.party_index);
3590: l_error_msg := fnd_message.get;
3591: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3592: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3593: 'Party Signed Date is missing');
3594: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3616: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_SIGNED_DATE');

3612: l_signed_date := to_date(l_import_parties_rec.signed_date, G_IMP_DATE_FORMAT);
3613: EXCEPTION
3614: WHEN OTHERS THEN
3615: l_valid_flag := 'N';
3616: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_SIGNED_DATE');
3617: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3618: VALUE => l_import_parties_rec.party_index);
3619: l_error_msg := fnd_message.get;
3620:

Line 3617: fnd_message.set_token(TOKEN => 'PARTY_INDEX',

3613: EXCEPTION
3614: WHEN OTHERS THEN
3615: l_valid_flag := 'N';
3616: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_SIGNED_DATE');
3617: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3618: VALUE => l_import_parties_rec.party_index);
3619: l_error_msg := fnd_message.get;
3620:
3621: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3619: l_error_msg := fnd_message.get;

3615: l_valid_flag := 'N';
3616: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_SIGNED_DATE');
3617: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3618: VALUE => l_import_parties_rec.party_index);
3619: l_error_msg := fnd_message.get;
3620:
3621: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3622: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3623: 'Party Signed Date is not valid');

Line 3672: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_PARTY_ROLE');

3668: IF(l_valid_flag = 'N') THEN
3669:
3670: --ROLE_NOT_EXIST - Party role doesn't exist
3671: IF l_error_code = 'ROLE_NOT_EXIST' THEN
3672: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_PARTY_ROLE');
3673: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3674: VALUE => l_import_parties_rec.party_index);
3675: l_error_msg := fnd_message.get;
3676: END IF;

Line 3673: fnd_message.set_token(TOKEN => 'PARTY_INDEX',

3669:
3670: --ROLE_NOT_EXIST - Party role doesn't exist
3671: IF l_error_code = 'ROLE_NOT_EXIST' THEN
3672: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_PARTY_ROLE');
3673: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3674: VALUE => l_import_parties_rec.party_index);
3675: l_error_msg := fnd_message.get;
3676: END IF;
3677:

Line 3675: l_error_msg := fnd_message.get;

3671: IF l_error_code = 'ROLE_NOT_EXIST' THEN
3672: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_PARTY_ROLE');
3673: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3674: VALUE => l_import_parties_rec.party_index);
3675: l_error_msg := fnd_message.get;
3676: END IF;
3677:
3678: --INV_ROLE_INTENT - Party role and Contract intent combination is invalid
3679: IF l_error_code = 'INV_ROLE_INTENT' THEN

Line 3680: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_ROLE_INTENT');

3676: END IF;
3677:
3678: --INV_ROLE_INTENT - Party role and Contract intent combination is invalid
3679: IF l_error_code = 'INV_ROLE_INTENT' THEN
3680: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_ROLE_INTENT');
3681: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3682: VALUE => l_import_parties_rec.party_index);
3683: l_error_msg := fnd_message.get;
3684:

Line 3681: fnd_message.set_token(TOKEN => 'PARTY_INDEX',

3677:
3678: --INV_ROLE_INTENT - Party role and Contract intent combination is invalid
3679: IF l_error_code = 'INV_ROLE_INTENT' THEN
3680: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_ROLE_INTENT');
3681: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3682: VALUE => l_import_parties_rec.party_index);
3683: l_error_msg := fnd_message.get;
3684:
3685: END IF;

Line 3683: l_error_msg := fnd_message.get;

3679: IF l_error_code = 'INV_ROLE_INTENT' THEN
3680: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_ROLE_INTENT');
3681: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3682: VALUE => l_import_parties_rec.party_index);
3683: l_error_msg := fnd_message.get;
3684:
3685: END IF;
3686:
3687: --PARTY_NOT_EXIST - Party doesn't exist

Line 3689: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_PARTY_NAME');

3685: END IF;
3686:
3687: --PARTY_NOT_EXIST - Party doesn't exist
3688: IF l_error_code = 'PARTY_NOT_EXIST' THEN
3689: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_PARTY_NAME');
3690: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3691: VALUE => l_import_parties_rec.party_index);
3692: l_error_msg := fnd_message.get;
3693: END IF;

Line 3690: fnd_message.set_token(TOKEN => 'PARTY_INDEX',

3686:
3687: --PARTY_NOT_EXIST - Party doesn't exist
3688: IF l_error_code = 'PARTY_NOT_EXIST' THEN
3689: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_PARTY_NAME');
3690: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3691: VALUE => l_import_parties_rec.party_index);
3692: l_error_msg := fnd_message.get;
3693: END IF;
3694:

Line 3692: l_error_msg := fnd_message.get;

3688: IF l_error_code = 'PARTY_NOT_EXIST' THEN
3689: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_PARTY_NAME');
3690: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3691: VALUE => l_import_parties_rec.party_index);
3692: l_error_msg := fnd_message.get;
3693: END IF;
3694:
3695: --INV_CUST_ACCT - Customer party doesn't have any customer accounts
3696: IF l_error_code = 'INV_CUST_ACCT' THEN

Line 3697: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_CUST_PARTY');

3693: END IF;
3694:
3695: --INV_CUST_ACCT - Customer party doesn't have any customer accounts
3696: IF l_error_code = 'INV_CUST_ACCT' THEN
3697: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_CUST_PARTY');
3698: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3699: VALUE => l_import_parties_rec.party_index);
3700: l_error_msg := fnd_message.get;
3701: END IF;

Line 3698: fnd_message.set_token(TOKEN => 'PARTY_INDEX',

3694:
3695: --INV_CUST_ACCT - Customer party doesn't have any customer accounts
3696: IF l_error_code = 'INV_CUST_ACCT' THEN
3697: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_CUST_PARTY');
3698: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3699: VALUE => l_import_parties_rec.party_index);
3700: l_error_msg := fnd_message.get;
3701: END IF;
3702:

Line 3700: l_error_msg := fnd_message.get;

3696: IF l_error_code = 'INV_CUST_ACCT' THEN
3697: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_CUST_PARTY');
3698: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3699: VALUE => l_import_parties_rec.party_index);
3700: l_error_msg := fnd_message.get;
3701: END IF;
3702:
3703: --PARTY_NOT_UNIQUE - Party in not unique in the Contract
3704: IF l_error_code = 'PARTY_NOT_UNIQUE' THEN

Line 3705: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_NONUNIQUE_PARTY');

3701: END IF;
3702:
3703: --PARTY_NOT_UNIQUE - Party in not unique in the Contract
3704: IF l_error_code = 'PARTY_NOT_UNIQUE' THEN
3705: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_NONUNIQUE_PARTY');
3706: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3707: VALUE => l_import_parties_rec.party_index);
3708: l_error_msg := fnd_message.get;
3709:

Line 3706: fnd_message.set_token(TOKEN => 'PARTY_INDEX',

3702:
3703: --PARTY_NOT_UNIQUE - Party in not unique in the Contract
3704: IF l_error_code = 'PARTY_NOT_UNIQUE' THEN
3705: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_NONUNIQUE_PARTY');
3706: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3707: VALUE => l_import_parties_rec.party_index);
3708: l_error_msg := fnd_message.get;
3709:
3710: END IF;

Line 3708: l_error_msg := fnd_message.get;

3704: IF l_error_code = 'PARTY_NOT_UNIQUE' THEN
3705: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_NONUNIQUE_PARTY');
3706: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3707: VALUE => l_import_parties_rec.party_index);
3708: l_error_msg := fnd_message.get;
3709:
3710: END IF;
3711:
3712: END IF;

Line 3729: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_CON_TYPE');

3725: --Also populate the error table
3726: --Note that in this case we do not wait until the end to populate the error table
3727: --because this time the error type is 'CONTRACT' and not 'PARTY'.
3728: --The party may still be valid by itself.
3729: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_CON_TYPE');
3730: populate_import_errors(p_init_msg_list => FND_API.G_FALSE,
3731: p_api_version => 1.0,
3732: p_contract_id => l_import_parties_rec.imp_contract_id,
3733: p_error_obj_type => G_IMP_CONTRACT_ERROR,

Line 4200: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_NAME');

4196: 'Checking if user enters contract name');
4197: END IF;
4198: IF (l_valid_flag = 'Y' AND l_import_contracts_rec.contract_name IS NULL) THEN
4199: l_valid_flag := 'N';
4200: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_NAME');
4201: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4202: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4203: 'Contract Name is missing');
4204: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4219: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_NAME');

4215: 'Checking if contract name is too long');
4216: END IF;
4217: IF (l_valid_flag = 'Y' AND LENGTH(l_import_contracts_rec.contract_name)>l_contract_name_length) THEN
4218: l_valid_flag := 'N';
4219: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_NAME');
4220: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4221: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4222: 'Contract Name is too long');
4223: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4245: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_SWB_INV_INTENT');

4241: 'l_contract_intent: '||l_contract_intent);
4242: END IF;
4243: IF ((is_sales_workbench() = 'Y') AND (l_contract_intent = G_INTENT_BUY)) THEN
4244: l_valid_flag := 'N';
4245: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_SWB_INV_INTENT');
4246: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4247: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4248: 'Buy Intent Contract can not be imported in Sales Workbench ');
4249: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4265: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_ORIG_CODE');

4261: 'Checking if Original System Reference Code is too long');
4262: END IF;
4263: IF (l_valid_flag = 'Y' AND LENGTH(l_import_contracts_rec.orig_system_reference_code)>l_orig_system_code_length) THEN
4264: l_valid_flag := 'N';
4265: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_ORIG_CODE');
4266: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4267: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4268: 'Original System Reference Code is too long');
4269: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4284: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_ORIG_ID1');

4280: 'Checking if Original System ID1 is too long');
4281: END IF;
4282: IF (l_valid_flag = 'Y' AND LENGTH(l_import_contracts_rec.orig_system_reference_id1)>l_orig_system_id1_length) THEN
4283: l_valid_flag := 'N';
4284: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_ORIG_ID1');
4285: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4286: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4287: 'Original System ID1 is too long');
4288: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4303: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_ORIG_ID2');

4299: 'Checking if Original System ID2 is too long');
4300: END IF;
4301: IF (l_valid_flag = 'Y' AND LENGTH(l_import_contracts_rec.orig_system_reference_id2)>l_orig_system_id2_length) THEN
4302: l_valid_flag := 'N';
4303: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_ORIG_ID2');
4304: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4305: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4306: 'Original System ID2 is too long');
4307: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4327: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_STATUS');

4323: END IF;
4324:
4325: IF (l_valid_flag = 'Y' AND (l_import_contracts_rec.contract_status_txt IS NULL OR LENGTH(l_import_contracts_rec.contract_status_txt)=0)) THEN
4326: l_valid_flag := 'N';
4327: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_STATUS');
4328: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4329: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4330: 'Contract Status is missing');
4331: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4351: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_STATUS');

4347: FETCH CONTRACT_STATUS_CSR INTO l_status_code;
4348: IF CONTRACT_STATUS_CSR%NOTFOUND THEN
4349: l_valid_flag := 'N';
4350: l_status_code := NULL;
4351: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_STATUS');
4352: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4353: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4354: 'Contract Status is invalid');
4355: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4369: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_STATUS');

4365: FETCH CONTRACT_STATUS_CSR_SQL INTO l_status_code;
4366: IF CONTRACT_STATUS_CSR_SQL%NOTFOUND THEN
4367: l_valid_flag := 'N';
4368: l_status_code := NULL;
4369: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_STATUS');
4370: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4371: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4372: 'Contract Status is invalid');
4373: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4396: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_CON_TYPE');

4392: l_import_contracts_rec.contract_type_txt := RTRIM(l_import_contracts_rec.contract_type_txt);
4393: END IF;
4394: IF (l_valid_flag = 'Y' AND (l_import_contracts_rec.contract_type_txt IS NULL OR LENGTH(l_import_contracts_rec.contract_type_txt)=0)) THEN
4395: l_valid_flag := 'N';
4396: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_CON_TYPE');
4397: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4398: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4399: 'Contract Type is missing');
4400: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4418: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_CON_TYPE');

4414: OPEN CONTRACT_TYPE_CSR(l_import_contracts_rec.contract_type_txt);
4415: FETCH CONTRACT_TYPE_CSR INTO l_contract_type;
4416: IF CONTRACT_TYPE_CSR%NOTFOUND THEN
4417: l_valid_flag := 'N';
4418: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_CON_TYPE');
4419: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4420: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4421: 'Contract Type is invalid');
4422: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4444: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_EFF_DATE');

4440: END IF;
4441:
4442: IF (l_valid_flag = 'Y' AND (l_import_contracts_rec.contract_effective_date IS NULL OR LENGTH(l_import_contracts_rec.contract_effective_date)=0)) THEN
4443: l_valid_flag := 'N';
4444: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_EFF_DATE');
4445: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4446: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4447: 'Contract Effective Date is missing');
4448: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4467: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_EFF_DATE');

4463: l_effective_date := to_date(l_import_contracts_rec.contract_effective_date, G_IMP_DATE_FORMAT);
4464: EXCEPTION
4465: WHEN OTHERS THEN
4466: l_valid_flag := 'N';
4467: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_EFF_DATE');
4468: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4469: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4470: 'Contract Effective Date is not valid');
4471: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4491: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_EXP_DATE');

4487: l_expiration_date := to_date(l_import_contracts_rec.contract_expiration_date, G_IMP_DATE_FORMAT);
4488: EXCEPTION
4489: WHEN OTHERS THEN
4490: l_valid_flag := 'N';
4491: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_EXP_DATE');
4492: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4493: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4494: 'Contract Expiration Date is not valid');
4495: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4517: --l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_EXP_BEFORE_EFF');

4513: --so it is safe to convert the dates
4514: IF TRUNC(to_date(l_import_contracts_rec.contract_effective_date,G_IMP_DATE_FORMAT)) > TRUNC(to_date(l_import_contracts_rec.contract_expiration_date,G_IMP_DATE_FORMAT)) THEN
4515: l_valid_flag := 'N';
4516: --Acq Plan Message Cleanup
4517: --l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_EXP_BEFORE_EFF');
4518:
4519: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_IMP_EXP_BEFORE_EFF',l_contract_type);
4520: l_resolved_token := OKC_API.resolve_hdr_token(l_contract_type);
4521:

Line 4522: --l_error_msg := fnd_message.get_string(G_APP_NAME,l_resolved_msg_name,p_token1=>'HDR_TOKEN',p_token1_value => l_resolved_token);

4518:
4519: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_IMP_EXP_BEFORE_EFF',l_contract_type);
4520: l_resolved_token := OKC_API.resolve_hdr_token(l_contract_type);
4521:
4522: --l_error_msg := fnd_message.get_string(G_APP_NAME,l_resolved_msg_name,p_token1=>'HDR_TOKEN',p_token1_value => l_resolved_token);
4523:
4524: l_error_msg := OKC_TERMS_UTIL_PVT.Get_Message(G_APP_NAME,l_resolved_msg_name,p_token1=>'HDR_TOKEN',p_token1_value => l_resolved_token);
4525: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4526: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4548: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_ORG');

4544: l_import_contracts_rec.org_name := RTRIM(l_import_contracts_rec.org_name);
4545: END IF;
4546: IF (l_valid_flag = 'Y' AND (l_import_contracts_rec.org_name IS NULL OR LENGTH(l_import_contracts_rec.org_name)=0)) THEN
4547: l_valid_flag := 'N';
4548: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_ORG');
4549: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4550: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4551: 'Operating Unit is missing');
4552: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4570: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_ORG');

4566: OPEN ORG_NAME_CSR(l_import_contracts_rec.org_name);
4567: FETCH ORG_NAME_CSR INTO l_org_id;
4568: IF ORG_NAME_CSR%NOTFOUND THEN
4569: l_valid_flag := 'N';
4570: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_ORG');
4571: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4572: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4573: 'Operating Unit is invalid');
4574: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4640: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_NONNULL_NUMBER');

4636: --contract_number has to be null
4637: --otherwise system should error out
4638: IF(l_import_contracts_rec.contract_number IS NOT NULL) THEN
4639: l_valid_flag := 'N';
4640: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_NONNULL_NUMBER');
4641: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4642: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4643: 'Auto number is turned on, but contract number is not null');
4644: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4710: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_NUMBER');

4706: END IF;
4707:
4708: IF (l_con_num_hook IS NULL) THEN
4709: l_valid_flag := 'N';
4710: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_NUMBER');
4711: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4712: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4713: 'Auto number is turned off, but contract number is missing');
4714: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4727: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_NUMBER');

4723: --contract number is entered
4724: --we need to check for length
4725: IF(LENGTH(l_import_contracts_rec.contract_number) > l_contract_number_length) THEN
4726: l_valid_flag := 'N';
4727: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_NUMBER');
4728: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4729: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4730: 'Conract number is too long');
4731: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4751: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_NONUNIQUE_NUMBER');

4747:
4748: FETCH CONTRACT_NUMBER_UNIQUE_CSR INTO l_unique_contract_number;
4749: IF CONTRACT_NUMBER_UNIQUE_CSR%FOUND THEN
4750: l_valid_flag := 'N';
4751: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_NONUNIQUE_NUMBER');
4752: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4753: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4754: 'Conract number is not unique for the contract_type '|| l_import_contracts_rec.contract_type_txt || ' and org_name '||l_import_contracts_rec.org_name);
4755: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4777: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_OWNER');

4773: l_import_contracts_rec.owner_user_name := RTRIM(l_import_contracts_rec.owner_user_name);
4774: END IF;
4775: IF (l_valid_flag = 'Y' AND (l_import_contracts_rec.owner_user_name IS NULL OR LENGTH(l_import_contracts_rec.owner_user_name)=0)) THEN
4776: l_valid_flag := 'N';
4777: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_OWNER');
4778: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4779: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4780: 'Owner User Name is missing');
4781: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4800: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_OWNER');

4796: OPEN OWNER_NAME_CSR(l_import_contracts_rec.owner_user_name);
4797: FETCH OWNER_NAME_CSR INTO l_owner_user_id;
4798: IF OWNER_NAME_CSR%NOTFOUND THEN
4799: l_valid_flag := 'N';
4800: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_OWNER');
4801: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4802: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4803: 'Owner User Name is invalid');
4804: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4827: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_CURRENCY');

4823: IF (l_valid_flag = 'Y'
4824: AND l_import_contracts_rec.contract_amount IS NOT NULL
4825: AND (l_import_contracts_rec.currency_code IS NULL OR LENGTH(l_import_contracts_rec.currency_code)=0)) THEN
4826: l_valid_flag := 'N';
4827: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_CURRENCY');
4828: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4829: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4830: 'Owner User Name is missing');
4831: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4849: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_CURRENCY');

4845: OPEN CURRENCY_CSR(l_import_contracts_rec.currency_code);
4846: FETCH CURRENCY_CSR INTO l_currency_code;
4847: IF CURRENCY_CSR%NOTFOUND THEN
4848: l_valid_flag := 'N';
4849: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_CURRENCY');
4850: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4851: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4852: 'Currency is invalid');
4853: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4880: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_AMOUNT');

4876:
4877: EXCEPTION
4878: WHEN OTHERS THEN
4879: l_valid_flag := 'N';
4880: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_AMOUNT');
4881: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4882: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4883: 'Amount is not valid');
4884: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4905: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_AUTH_PARTY');

4901: OPEN AUTHORING_PARTY_CSR(l_import_contracts_rec.authoring_party_txt);
4902: FETCH AUTHORING_PARTY_CSR INTO l_authoring_party_code;
4903: IF AUTHORING_PARTY_CSR%NOTFOUND THEN
4904: l_valid_flag := 'N';
4905: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_AUTH_PARTY');
4906: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4907: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4908: 'Authoring Party is invalid');
4909: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4926: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_LOCATION');

4922: 'Checking if Physical Location is too long');
4923: END IF;
4924: IF (l_valid_flag = 'Y' AND LENGTH(l_import_contracts_rec.physical_location)>l_location_length) THEN
4925: l_valid_flag := 'N';
4926: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_LOCATION');
4927: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4928: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4929: 'Physical Location is too long');
4930: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4945: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_KEYWORDS');

4941: 'Checking if keywords is too long');
4942: END IF;
4943: IF (l_valid_flag = 'Y' AND LENGTH(l_import_contracts_rec.keywords)>l_keywords_length) THEN
4944: l_valid_flag := 'N';
4945: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_KEYWORDS');
4946: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4947: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4948: 'Keywords is too long');
4949: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4964: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_DESC');

4960: 'Checking if description is too long');
4961: END IF;
4962: IF (l_valid_flag = 'Y' AND LENGTH(l_import_contracts_rec.description)>l_description_length) THEN
4963: l_valid_flag := 'N';
4964: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_DESC');
4965: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4966: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4967: 'Description is too long');
4968: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4983: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_COMMENTS');

4979: 'Checking if version comments is too long');
4980: END IF;
4981: IF (l_valid_flag = 'Y' AND LENGTH(l_import_contracts_rec.version_comments)>l_version_comments_length) THEN
4982: l_valid_flag := 'N';
4983: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_COMMENTS');
4984: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4985: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4986: 'Version Comments is too long');
4987: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 5020: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_INT_PARTIES');

5016: CLOSE CONTRACT_PARTIES_CSR;
5017:
5018: IF l_int_parties_count <> 1 THEN
5019: l_valid_flag := 'N';
5020: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_INT_PARTIES');
5021: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5022: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5023: 'There are not exactly one internal party');
5024: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 5033: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_INT_PARTY_NAME');

5029: ELSE
5030: --fix bug 4160416, need to validate internal party name with the org name in the header
5031: IF l_import_contracts_rec.org_name <> l_int_party_name THEN
5032: l_valid_flag := 'N';
5033: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_INT_PARTY_NAME');
5034: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5035: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5036: 'Internal party name and org name are not matching');
5037: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 5049: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_EXT_PARTIES');

5045: --kkolukul: External party not mandatory
5046: /*
5047: IF l_ext_parties_count <1 THEN
5048: l_valid_flag := 'N';
5049: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_EXT_PARTIES');
5050: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5051: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5052: 'There are less than one external party');
5053: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 5071: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_COMMENTS');

5067: 'Checking if version comments is too long');
5068: END IF;
5069: IF (l_valid_flag = 'Y' AND LENGTH(l_import_contracts_rec.termination_comments)>l_termin_comments_length) THEN
5070: l_valid_flag := 'N';
5071: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_COMMENTS');
5072: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5073: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5074: 'Termination comments is too long');
5075: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 5092: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_COMMENTS');

5088:
5089:
5090: IF (l_valid_flag = 'Y' AND LENGTH(l_import_contracts_rec.cancellation_comments)>l_cancel_comments_length) THEN
5091: l_valid_flag := 'N';
5092: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_COMMENTS');
5093: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5094: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5095: 'cancellation comments is too long');
5096: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 5115: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_EXP_DATE');

5111: l_expiration_date := to_date(l_import_contracts_rec.cancellation_date, G_IMP_DATE_FORMAT);
5112: EXCEPTION
5113: WHEN OTHERS THEN
5114: l_valid_flag := 'N';
5115: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_EXP_DATE');
5116: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5117: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5118: 'Contract Expiration Date is not valid');
5119: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 5139: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_EXP_DATE');

5135: l_expiration_date := to_date(l_import_contracts_rec.termination_date, G_IMP_DATE_FORMAT);
5136: EXCEPTION
5137: WHEN OTHERS THEN
5138: l_valid_flag := 'N';
5139: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_EXP_DATE');
5140: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5141: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5142: 'Contract Expiration Date is not valid');
5143: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 5162: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_RISK_CODE');

5158: OPEN OVERALL_RISK_CSR(l_import_contracts_rec.overall_risk_txt);
5159: FETCH OVERALL_RISK_CSR INTO l_overall_risk_code;
5160: IF OVERALL_RISK_CSR%NOTFOUND THEN
5161: l_valid_flag := 'N';
5162: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_RISK_CODE');
5163: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5164: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5165: 'Overall Risk is invalid');
5166: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 5183: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_COMMENTS');

5179: 'Checking if Attribute Category is too long');
5180: END IF;
5181: IF (l_valid_flag = 'Y' AND LENGTH(l_import_contracts_rec.attribute_category) > l_attr_category_length) THEN
5182: l_valid_flag := 'N';
5183: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_COMMENTS');
5184: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5185: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5186: 'cancellation comments is too long');
5187: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 5205: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_COMMENTS');

5201: /* FOR i IN 1..15 LOOP
5202: --Need to check if this syntax works.
5203: IF (l_valid_flag = 'Y' AND LENGTH(l_import_contracts_rec.attribute||i) > l_attribute_length) THEN
5204: l_valid_flag := 'N';
5205: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_COMMENTS');
5206: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5207: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5208: 'Attribute'||i||' is too long');
5209: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 5228: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_NOTIFY_ROLE');

5224: OPEN notify_role_csr(l_import_contracts_rec.notify_contact_role_txt);
5225: FETCH notify_role_csr INTO l_notify_contact_role_id;
5226: IF notify_role_csr%NOTFOUND THEN
5227: l_valid_flag := 'N';
5228: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_NOTIFY_ROLE');
5229: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5230: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5231: 'Overall Risk is invalid');
5232: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 8534: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_NAME');

8530: END IF;
8531: IF (l_valid_flag = 'Y' AND (l_import_contacts_rec.party_name_txt IS NULL OR LENGTH(l_import_contacts_rec.party_name_txt)=0)) THEN
8532: l_valid_flag := 'N';
8533:
8534: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_NAME');
8535: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8536: VALUE => l_import_contacts_rec.contact_index);
8537: l_error_msg := fnd_message.get;
8538: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 8535: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',

8531: IF (l_valid_flag = 'Y' AND (l_import_contacts_rec.party_name_txt IS NULL OR LENGTH(l_import_contacts_rec.party_name_txt)=0)) THEN
8532: l_valid_flag := 'N';
8533:
8534: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_NAME');
8535: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8536: VALUE => l_import_contacts_rec.contact_index);
8537: l_error_msg := fnd_message.get;
8538: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8539: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 8537: l_error_msg := fnd_message.get;

8533:
8534: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_NAME');
8535: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8536: VALUE => l_import_contacts_rec.contact_index);
8537: l_error_msg := fnd_message.get;
8538: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8539: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
8540: 'Party Name is missing for this contact');
8541: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 8563: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_ROLE');

8559: END IF;
8560: IF (l_valid_flag = 'Y' AND (l_import_contacts_rec.party_role_txt IS NULL OR LENGTH(l_import_contacts_rec.party_role_txt)=0)) THEN
8561: l_valid_flag := 'N';
8562:
8563: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_ROLE');
8564: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8565: VALUE => l_import_contacts_rec.contact_index);
8566: l_error_msg := fnd_message.get;
8567: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 8564: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',

8560: IF (l_valid_flag = 'Y' AND (l_import_contacts_rec.party_role_txt IS NULL OR LENGTH(l_import_contacts_rec.party_role_txt)=0)) THEN
8561: l_valid_flag := 'N';
8562:
8563: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_ROLE');
8564: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8565: VALUE => l_import_contacts_rec.contact_index);
8566: l_error_msg := fnd_message.get;
8567: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8568: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 8566: l_error_msg := fnd_message.get;

8562:
8563: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_ROLE');
8564: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8565: VALUE => l_import_contacts_rec.contact_index);
8566: l_error_msg := fnd_message.get;
8567: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8568: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
8569: 'Party Role is missing for this contact');
8570: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 8599: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_ROLE');

8595: --CLOSE internal_party_contact_csr;
8596:
8597: l_valid_flag := 'N';
8598:
8599: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_ROLE');
8600: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8601: VALUE => l_import_contacts_rec.contact_index);
8602: l_error_msg := fnd_message.get;
8603: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 8600: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',

8596:
8597: l_valid_flag := 'N';
8598:
8599: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_ROLE');
8600: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8601: VALUE => l_import_contacts_rec.contact_index);
8602: l_error_msg := fnd_message.get;
8603: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8604: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 8602: l_error_msg := fnd_message.get;

8598:
8599: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_ROLE');
8600: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8601: VALUE => l_import_contacts_rec.contact_index);
8602: l_error_msg := fnd_message.get;
8603: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8604: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
8605: 'Party missing on contract');
8606: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 8631: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_CONTACT_ROLE');

8627: END IF;
8628: IF (l_valid_flag = 'Y' AND (l_import_contacts_rec.contact_role_txt IS NULL OR LENGTH(l_import_contacts_rec.contact_role_txt)=0)) THEN
8629: l_valid_flag := 'N';
8630:
8631: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_CONTACT_ROLE');
8632: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8633: VALUE => l_import_contacts_rec.contact_index);
8634: l_error_msg := fnd_message.get;
8635: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 8632: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',

8628: IF (l_valid_flag = 'Y' AND (l_import_contacts_rec.contact_role_txt IS NULL OR LENGTH(l_import_contacts_rec.contact_role_txt)=0)) THEN
8629: l_valid_flag := 'N';
8630:
8631: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_CONTACT_ROLE');
8632: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8633: VALUE => l_import_contacts_rec.contact_index);
8634: l_error_msg := fnd_message.get;
8635: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8636: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 8634: l_error_msg := fnd_message.get;

8630:
8631: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_CONTACT_ROLE');
8632: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8633: VALUE => l_import_contacts_rec.contact_index);
8634: l_error_msg := fnd_message.get;
8635: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8636: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
8637: 'Contact Role is missing');
8638: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 8664: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_CONTACT_ROLE');

8660:
8661: IF (l_valid_flag = 'Y') THEN
8662: l_valid_flag := 'N';
8663:
8664: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_CONTACT_ROLE');
8665: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8666: VALUE => l_import_contacts_rec.contact_index);
8667: l_error_msg := fnd_message.get;
8668: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 8665: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',

8661: IF (l_valid_flag = 'Y') THEN
8662: l_valid_flag := 'N';
8663:
8664: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_CONTACT_ROLE');
8665: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8666: VALUE => l_import_contacts_rec.contact_index);
8667: l_error_msg := fnd_message.get;
8668: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8669: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 8667: l_error_msg := fnd_message.get;

8663:
8664: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_CONTACT_ROLE');
8665: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8666: VALUE => l_import_contacts_rec.contact_index);
8667: l_error_msg := fnd_message.get;
8668: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8669: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
8670: 'Contact Role is not valid');
8671: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 8698: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_CONTACT_ID');

8694: END IF;
8695: IF (l_valid_flag = 'Y' AND (l_import_contacts_rec.contact_id IS NULL OR LENGTH(l_import_contacts_rec.contact_id)=0)) THEN
8696: l_valid_flag := 'N';
8697:
8698: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_CONTACT_ID');
8699: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8700: VALUE => l_import_contacts_rec.contact_index);
8701: l_error_msg := fnd_message.get;
8702: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 8699: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',

8695: IF (l_valid_flag = 'Y' AND (l_import_contacts_rec.contact_id IS NULL OR LENGTH(l_import_contacts_rec.contact_id)=0)) THEN
8696: l_valid_flag := 'N';
8697:
8698: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_CONTACT_ID');
8699: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8700: VALUE => l_import_contacts_rec.contact_index);
8701: l_error_msg := fnd_message.get;
8702: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8703: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 8701: l_error_msg := fnd_message.get;

8697:
8698: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_CONTACT_ID');
8699: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8700: VALUE => l_import_contacts_rec.contact_index);
8701: l_error_msg := fnd_message.get;
8702: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8703: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
8704: 'Contact Id is missing');
8705: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 8742: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_CONTACT_NOT_UNIQUE');

8738: IF(l_valid_flag = 'N') THEN
8739:
8740: --Contact Not Unique
8741: IF l_error_code = 'CONTACT_NOT_UNIQUE' THEN
8742: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_CONTACT_NOT_UNIQUE');
8743: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8744: VALUE => l_import_contacts_rec.contact_index);
8745: l_error_msg := fnd_message.get;
8746: END IF;

Line 8743: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',

8739:
8740: --Contact Not Unique
8741: IF l_error_code = 'CONTACT_NOT_UNIQUE' THEN
8742: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_CONTACT_NOT_UNIQUE');
8743: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8744: VALUE => l_import_contacts_rec.contact_index);
8745: l_error_msg := fnd_message.get;
8746: END IF;
8747:

Line 8745: l_error_msg := fnd_message.get;

8741: IF l_error_code = 'CONTACT_NOT_UNIQUE' THEN
8742: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_CONTACT_NOT_UNIQUE');
8743: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8744: VALUE => l_import_contacts_rec.contact_index);
8745: l_error_msg := fnd_message.get;
8746: END IF;
8747:
8748: --INV_ROLE_INTENT - Party role and Contract intent combination is invalid
8749: IF l_error_code = 'CONTACT_NOT_EXIST' THEN

Line 8750: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_CONTACT');

8746: END IF;
8747:
8748: --INV_ROLE_INTENT - Party role and Contract intent combination is invalid
8749: IF l_error_code = 'CONTACT_NOT_EXIST' THEN
8750: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_CONTACT');
8751: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8752: VALUE => l_import_contacts_rec.contact_index);
8753: l_error_msg := fnd_message.get;
8754:

Line 8751: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',

8747:
8748: --INV_ROLE_INTENT - Party role and Contract intent combination is invalid
8749: IF l_error_code = 'CONTACT_NOT_EXIST' THEN
8750: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_CONTACT');
8751: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8752: VALUE => l_import_contacts_rec.contact_index);
8753: l_error_msg := fnd_message.get;
8754:
8755: END IF;

Line 8753: l_error_msg := fnd_message.get;

8749: IF l_error_code = 'CONTACT_NOT_EXIST' THEN
8750: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_CONTACT');
8751: fnd_message.set_token(TOKEN => 'CONTACT_INDEX',
8752: VALUE => l_import_contacts_rec.contact_index);
8753: l_error_msg := fnd_message.get;
8754:
8755: END IF;
8756:
8757: END IF;

Line 9016: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_RISK_EVENT');

9012: END IF;
9013: IF (l_valid_flag = 'Y' AND (l_import_risks_rec.risk_event_txt IS NULL OR LENGTH(l_import_risks_rec.risk_event_txt)=0)) THEN
9014: l_valid_flag := 'N';
9015:
9016: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_RISK_EVENT');
9017: fnd_message.set_token(TOKEN => 'RISK_INDEX',
9018: VALUE => l_import_risks_rec.risk_index);
9019: l_error_msg := fnd_message.get;
9020: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 9017: fnd_message.set_token(TOKEN => 'RISK_INDEX',

9013: IF (l_valid_flag = 'Y' AND (l_import_risks_rec.risk_event_txt IS NULL OR LENGTH(l_import_risks_rec.risk_event_txt)=0)) THEN
9014: l_valid_flag := 'N';
9015:
9016: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_RISK_EVENT');
9017: fnd_message.set_token(TOKEN => 'RISK_INDEX',
9018: VALUE => l_import_risks_rec.risk_index);
9019: l_error_msg := fnd_message.get;
9020: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9021: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 9019: l_error_msg := fnd_message.get;

9015:
9016: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_RISK_EVENT');
9017: fnd_message.set_token(TOKEN => 'RISK_INDEX',
9018: VALUE => l_import_risks_rec.risk_index);
9019: l_error_msg := fnd_message.get;
9020: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9021: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
9022: 'Party Name is missing');
9023: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 9047: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_RISK_EVENT');

9043:
9044: IF (l_valid_flag = 'Y') THEN
9045: l_valid_flag := 'N';
9046:
9047: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_RISK_EVENT');
9048: fnd_message.set_token(TOKEN => 'RISK_INDEX',
9049: VALUE => l_import_risks_rec.risk_index);
9050: l_error_msg := fnd_message.get;
9051: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 9048: fnd_message.set_token(TOKEN => 'RISK_INDEX',

9044: IF (l_valid_flag = 'Y') THEN
9045: l_valid_flag := 'N';
9046:
9047: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_RISK_EVENT');
9048: fnd_message.set_token(TOKEN => 'RISK_INDEX',
9049: VALUE => l_import_risks_rec.risk_index);
9050: l_error_msg := fnd_message.get;
9051: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9052: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 9050: l_error_msg := fnd_message.get;

9046:
9047: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_RISK_EVENT');
9048: fnd_message.set_token(TOKEN => 'RISK_INDEX',
9049: VALUE => l_import_risks_rec.risk_index);
9050: l_error_msg := fnd_message.get;
9051: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9052: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
9053: 'Risk Event is not valid ');
9054: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 9083: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_RISK_PROB');

9079:
9080: IF (l_valid_flag = 'Y') THEN
9081: l_valid_flag := 'N';
9082:
9083: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_RISK_PROB');
9084: fnd_message.set_token(TOKEN => 'RISK_INDEX',
9085: VALUE => l_import_risks_rec.risk_index);
9086: l_error_msg := fnd_message.get;
9087: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 9084: fnd_message.set_token(TOKEN => 'RISK_INDEX',

9080: IF (l_valid_flag = 'Y') THEN
9081: l_valid_flag := 'N';
9082:
9083: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_RISK_PROB');
9084: fnd_message.set_token(TOKEN => 'RISK_INDEX',
9085: VALUE => l_import_risks_rec.risk_index);
9086: l_error_msg := fnd_message.get;
9087: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9088: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 9086: l_error_msg := fnd_message.get;

9082:
9083: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_RISK_PROB');
9084: fnd_message.set_token(TOKEN => 'RISK_INDEX',
9085: VALUE => l_import_risks_rec.risk_index);
9086: l_error_msg := fnd_message.get;
9087: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9088: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
9089: 'Risk Probability is not valid ');
9090: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 9119: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_RISK_IMPACT');

9115:
9116: IF (l_valid_flag = 'Y') THEN
9117: l_valid_flag := 'N';
9118:
9119: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_RISK_IMPACT');
9120: fnd_message.set_token(TOKEN => 'RISK_INDEX',
9121: VALUE => l_import_risks_rec.risk_index);
9122: l_error_msg := fnd_message.get;
9123: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 9120: fnd_message.set_token(TOKEN => 'RISK_INDEX',

9116: IF (l_valid_flag = 'Y') THEN
9117: l_valid_flag := 'N';
9118:
9119: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_RISK_IMPACT');
9120: fnd_message.set_token(TOKEN => 'RISK_INDEX',
9121: VALUE => l_import_risks_rec.risk_index);
9122: l_error_msg := fnd_message.get;
9123: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9124: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 9122: l_error_msg := fnd_message.get;

9118:
9119: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_RISK_IMPACT');
9120: fnd_message.set_token(TOKEN => 'RISK_INDEX',
9121: VALUE => l_import_risks_rec.risk_index);
9122: l_error_msg := fnd_message.get;
9123: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9124: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
9125: 'Risk Impact is not valid is not valid');
9126: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,