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 2834: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_DOC_NAME');

2830: END IF;
2831: IF (l_valid_flag = 'Y' AND (l_import_documents_rec.FILE_NAME IS NULL OR LENGTH(l_import_documents_rec.FILE_NAME)=0)) THEN
2832: l_valid_flag := 'N';
2833:
2834: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_DOC_NAME');
2835: fnd_message.set_token(TOKEN => 'DOC_INDEX',
2836: VALUE => l_import_documents_rec.document_index);
2837: l_error_msg := fnd_message.get;
2838: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2831: IF (l_valid_flag = 'Y' AND (l_import_documents_rec.FILE_NAME IS NULL OR LENGTH(l_import_documents_rec.FILE_NAME)=0)) THEN
2832: l_valid_flag := 'N';
2833:
2834: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_DOC_NAME');
2835: fnd_message.set_token(TOKEN => 'DOC_INDEX',
2836: VALUE => l_import_documents_rec.document_index);
2837: l_error_msg := fnd_message.get;
2838: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2839: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 2837: l_error_msg := fnd_message.get;

2833:
2834: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_DOC_NAME');
2835: fnd_message.set_token(TOKEN => 'DOC_INDEX',
2836: VALUE => l_import_documents_rec.document_index);
2837: l_error_msg := fnd_message.get;
2838: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2839: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2840: 'Document Name is missing');
2841: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

2858: --File Name should be <= 256
2859: IF (l_valid_flag = 'Y' AND LENGTH(l_import_documents_rec.file_name) > l_file_name_length) THEN
2860: l_valid_flag := 'N';
2861:
2862: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_LONG_DOC_NAME');
2863: fnd_message.set_token(TOKEN => 'DOC_INDEX',
2864: VALUE => l_import_documents_rec.document_index);
2865: l_error_msg := fnd_message.get;
2866: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2859: IF (l_valid_flag = 'Y' AND LENGTH(l_import_documents_rec.file_name) > l_file_name_length) THEN
2860: l_valid_flag := 'N';
2861:
2862: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_LONG_DOC_NAME');
2863: fnd_message.set_token(TOKEN => 'DOC_INDEX',
2864: VALUE => l_import_documents_rec.document_index);
2865: l_error_msg := fnd_message.get;
2866: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2867: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 2865: l_error_msg := fnd_message.get;

2861:
2862: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_LONG_DOC_NAME');
2863: fnd_message.set_token(TOKEN => 'DOC_INDEX',
2864: VALUE => l_import_documents_rec.document_index);
2865: l_error_msg := fnd_message.get;
2866: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2867: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2868: 'Document Name is too long');
2869: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

2883: --File Name should be <= 256
2884: 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
2885: l_valid_flag := 'N';
2886:
2887: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_LONG_DOC_DESC');
2888: fnd_message.set_token(TOKEN => 'DOC_INDEX',
2889: VALUE => l_import_documents_rec.document_index);
2890: l_error_msg := fnd_message.get;
2891: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2884: 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
2885: l_valid_flag := 'N';
2886:
2887: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_LONG_DOC_DESC');
2888: fnd_message.set_token(TOKEN => 'DOC_INDEX',
2889: VALUE => l_import_documents_rec.document_index);
2890: l_error_msg := fnd_message.get;
2891: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2892: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 2890: l_error_msg := fnd_message.get;

2886:
2887: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_LONG_DOC_DESC');
2888: fnd_message.set_token(TOKEN => 'DOC_INDEX',
2889: VALUE => l_import_documents_rec.document_index);
2890: l_error_msg := fnd_message.get;
2891: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2892: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2893: 'Document Description is too long');
2894: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

2914: 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
2915: l_valid_flag := 'N';
2916: l_category_code := NULL;
2917:
2918: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_DOC_CATEGORY');
2919: fnd_message.set_token(TOKEN => 'DOC_INDEX',
2920: VALUE => l_import_documents_rec.document_index);
2921: l_error_msg := fnd_message.get;
2922: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2915: l_valid_flag := 'N';
2916: l_category_code := NULL;
2917:
2918: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_DOC_CATEGORY');
2919: fnd_message.set_token(TOKEN => 'DOC_INDEX',
2920: VALUE => l_import_documents_rec.document_index);
2921: l_error_msg := fnd_message.get;
2922: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2923: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 2921: l_error_msg := fnd_message.get;

2917:
2918: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_DOC_CATEGORY');
2919: fnd_message.set_token(TOKEN => 'DOC_INDEX',
2920: VALUE => l_import_documents_rec.document_index);
2921: l_error_msg := fnd_message.get;
2922: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2923: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2924: 'Document Category is missing');
2925: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

2944: IF document_category_csr%NOTFOUND THEN
2945: l_valid_flag := 'N';
2946: l_category_code := NULL;
2947:
2948: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_DOC_CATEGORY');
2949: fnd_message.set_token(TOKEN => 'DOC_INDEX',
2950: VALUE => l_import_documents_rec.document_index);
2951: l_error_msg := fnd_message.get;
2952: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2945: l_valid_flag := 'N';
2946: l_category_code := NULL;
2947:
2948: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_DOC_CATEGORY');
2949: fnd_message.set_token(TOKEN => 'DOC_INDEX',
2950: VALUE => l_import_documents_rec.document_index);
2951: l_error_msg := fnd_message.get;
2952: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2953: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 2951: l_error_msg := fnd_message.get;

2947:
2948: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_DOC_CATEGORY');
2949: fnd_message.set_token(TOKEN => 'DOC_INDEX',
2950: VALUE => l_import_documents_rec.document_index);
2951: l_error_msg := fnd_message.get;
2952: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2953: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2954: 'Category ID not found with given category name: '||l_import_documents_rec.category_name_txt);
2955: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

3193: END IF;
3194: 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
3195: l_valid_flag := 'N';
3196:
3197: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_NAME');
3198: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3199: VALUE => l_import_parties_rec.party_index);
3200: l_error_msg := fnd_message.get;
3201: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3194: 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
3195: l_valid_flag := 'N';
3196:
3197: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_NAME');
3198: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3199: VALUE => l_import_parties_rec.party_index);
3200: l_error_msg := fnd_message.get;
3201: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3202: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3200: l_error_msg := fnd_message.get;

3196:
3197: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_NAME');
3198: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3199: VALUE => l_import_parties_rec.party_index);
3200: l_error_msg := fnd_message.get;
3201: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3202: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3203: 'Party Name is missing');
3204: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

3222: END IF;
3223: 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
3224: l_valid_flag := 'N';
3225:
3226: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_ROLE');
3227: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3228: VALUE => l_import_parties_rec.party_index);
3229: l_error_msg := fnd_message.get;
3230: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3223: 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
3224: l_valid_flag := 'N';
3225:
3226: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_ROLE');
3227: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3228: VALUE => l_import_parties_rec.party_index);
3229: l_error_msg := fnd_message.get;
3230: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3231: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3229: l_error_msg := fnd_message.get;

3225:
3226: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_PARTY_ROLE');
3227: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3228: VALUE => l_import_parties_rec.party_index);
3229: l_error_msg := fnd_message.get;
3230: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3231: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3232: 'Party Role is missing');
3233: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

3252: END IF;
3253: 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
3254: l_valid_flag := 'N';
3255:
3256: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_SIGNED_BY');
3257: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3258: VALUE => l_import_parties_rec.party_index);
3259: l_error_msg := fnd_message.get;
3260: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3253: 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
3254: l_valid_flag := 'N';
3255:
3256: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_SIGNED_BY');
3257: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3258: VALUE => l_import_parties_rec.party_index);
3259: l_error_msg := fnd_message.get;
3260: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3261: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3259: l_error_msg := fnd_message.get;

3255:
3256: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_SIGNED_BY');
3257: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3258: VALUE => l_import_parties_rec.party_index);
3259: l_error_msg := fnd_message.get;
3260: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3261: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3262: 'Party Signed By is missing');
3263: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

3279: IF (l_valid_flag = 'Y' AND l_import_parties_rec.signed_by_txt IS NOT NULL
3280: AND LENGTH(l_import_parties_rec.signed_by_txt) > l_signed_by_length) THEN
3281: l_valid_flag := 'N';
3282:
3283: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_LONG_SIGNED_BY');
3284: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3285: VALUE => l_import_parties_rec.party_index);
3286: l_error_msg := fnd_message.get;
3287: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3280: AND LENGTH(l_import_parties_rec.signed_by_txt) > l_signed_by_length) THEN
3281: l_valid_flag := 'N';
3282:
3283: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_LONG_SIGNED_BY');
3284: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3285: VALUE => l_import_parties_rec.party_index);
3286: l_error_msg := fnd_message.get;
3287: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3288: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3286: l_error_msg := fnd_message.get;

3282:
3283: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_LONG_SIGNED_BY');
3284: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3285: VALUE => l_import_parties_rec.party_index);
3286: l_error_msg := fnd_message.get;
3287: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3288: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3289: 'Party Signed By is too long');
3290: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

3309: END IF;
3310: IF (l_valid_flag = 'Y' AND (l_import_parties_rec.signed_date IS NULL OR LENGTH(l_import_parties_rec.signed_date)=0)) THEN
3311: l_valid_flag := 'N';
3312:
3313: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_SIGNED_DATE');
3314: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3315: VALUE => l_import_parties_rec.party_index);
3316: l_error_msg := fnd_message.get;
3317: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3310: IF (l_valid_flag = 'Y' AND (l_import_parties_rec.signed_date IS NULL OR LENGTH(l_import_parties_rec.signed_date)=0)) THEN
3311: l_valid_flag := 'N';
3312:
3313: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_SIGNED_DATE');
3314: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3315: VALUE => l_import_parties_rec.party_index);
3316: l_error_msg := fnd_message.get;
3317: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3318: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 3316: l_error_msg := fnd_message.get;

3312:
3313: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_SIGNED_DATE');
3314: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3315: VALUE => l_import_parties_rec.party_index);
3316: l_error_msg := fnd_message.get;
3317: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3318: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3319: 'Party Signed Date is missing');
3320: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

3338: l_signed_date := to_date(l_import_parties_rec.signed_date, G_IMP_DATE_FORMAT);
3339: EXCEPTION
3340: WHEN OTHERS THEN
3341: l_valid_flag := 'N';
3342: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_SIGNED_DATE');
3343: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3344: VALUE => l_import_parties_rec.party_index);
3345: l_error_msg := fnd_message.get;
3346:

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

3339: EXCEPTION
3340: WHEN OTHERS THEN
3341: l_valid_flag := 'N';
3342: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_SIGNED_DATE');
3343: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3344: VALUE => l_import_parties_rec.party_index);
3345: l_error_msg := fnd_message.get;
3346:
3347: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3345: l_error_msg := fnd_message.get;

3341: l_valid_flag := 'N';
3342: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_SIGNED_DATE');
3343: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3344: VALUE => l_import_parties_rec.party_index);
3345: l_error_msg := fnd_message.get;
3346:
3347: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3348: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3349: 'Party Signed Date is not valid');

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

3392: IF(l_valid_flag = 'N') THEN
3393:
3394: --ROLE_NOT_EXIST - Party role doesn't exist
3395: IF l_error_code = 'ROLE_NOT_EXIST' THEN
3396: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_PARTY_ROLE');
3397: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3398: VALUE => l_import_parties_rec.party_index);
3399: l_error_msg := fnd_message.get;
3400: END IF;

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

3393:
3394: --ROLE_NOT_EXIST - Party role doesn't exist
3395: IF l_error_code = 'ROLE_NOT_EXIST' THEN
3396: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_PARTY_ROLE');
3397: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3398: VALUE => l_import_parties_rec.party_index);
3399: l_error_msg := fnd_message.get;
3400: END IF;
3401:

Line 3399: l_error_msg := fnd_message.get;

3395: IF l_error_code = 'ROLE_NOT_EXIST' THEN
3396: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_PARTY_ROLE');
3397: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3398: VALUE => l_import_parties_rec.party_index);
3399: l_error_msg := fnd_message.get;
3400: END IF;
3401:
3402: --INV_ROLE_INTENT - Party role and Contract intent combination is invalid
3403: IF l_error_code = 'INV_ROLE_INTENT' THEN

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

3400: END IF;
3401:
3402: --INV_ROLE_INTENT - Party role and Contract intent combination is invalid
3403: IF l_error_code = 'INV_ROLE_INTENT' THEN
3404: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_ROLE_INTENT');
3405: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3406: VALUE => l_import_parties_rec.party_index);
3407: l_error_msg := fnd_message.get;
3408:

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

3401:
3402: --INV_ROLE_INTENT - Party role and Contract intent combination is invalid
3403: IF l_error_code = 'INV_ROLE_INTENT' THEN
3404: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_ROLE_INTENT');
3405: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3406: VALUE => l_import_parties_rec.party_index);
3407: l_error_msg := fnd_message.get;
3408:
3409: END IF;

Line 3407: l_error_msg := fnd_message.get;

3403: IF l_error_code = 'INV_ROLE_INTENT' THEN
3404: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_ROLE_INTENT');
3405: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3406: VALUE => l_import_parties_rec.party_index);
3407: l_error_msg := fnd_message.get;
3408:
3409: END IF;
3410:
3411: --PARTY_NOT_EXIST - Party doesn't exist

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

3409: END IF;
3410:
3411: --PARTY_NOT_EXIST - Party doesn't exist
3412: IF l_error_code = 'PARTY_NOT_EXIST' THEN
3413: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_PARTY_NAME');
3414: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3415: VALUE => l_import_parties_rec.party_index);
3416: l_error_msg := fnd_message.get;
3417: END IF;

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

3410:
3411: --PARTY_NOT_EXIST - Party doesn't exist
3412: IF l_error_code = 'PARTY_NOT_EXIST' THEN
3413: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_PARTY_NAME');
3414: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3415: VALUE => l_import_parties_rec.party_index);
3416: l_error_msg := fnd_message.get;
3417: END IF;
3418:

Line 3416: l_error_msg := fnd_message.get;

3412: IF l_error_code = 'PARTY_NOT_EXIST' THEN
3413: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_PARTY_NAME');
3414: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3415: VALUE => l_import_parties_rec.party_index);
3416: l_error_msg := fnd_message.get;
3417: END IF;
3418:
3419: --INV_CUST_ACCT - Customer party doesn't have any customer accounts
3420: IF l_error_code = 'INV_CUST_ACCT' THEN

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

3417: END IF;
3418:
3419: --INV_CUST_ACCT - Customer party doesn't have any customer accounts
3420: IF l_error_code = 'INV_CUST_ACCT' THEN
3421: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_CUST_PARTY');
3422: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3423: VALUE => l_import_parties_rec.party_index);
3424: l_error_msg := fnd_message.get;
3425: END IF;

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

3418:
3419: --INV_CUST_ACCT - Customer party doesn't have any customer accounts
3420: IF l_error_code = 'INV_CUST_ACCT' THEN
3421: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_CUST_PARTY');
3422: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3423: VALUE => l_import_parties_rec.party_index);
3424: l_error_msg := fnd_message.get;
3425: END IF;
3426:

Line 3424: l_error_msg := fnd_message.get;

3420: IF l_error_code = 'INV_CUST_ACCT' THEN
3421: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_CUST_PARTY');
3422: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3423: VALUE => l_import_parties_rec.party_index);
3424: l_error_msg := fnd_message.get;
3425: END IF;
3426:
3427: --PARTY_NOT_UNIQUE - Party in not unique in the Contract
3428: IF l_error_code = 'PARTY_NOT_UNIQUE' THEN

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

3425: END IF;
3426:
3427: --PARTY_NOT_UNIQUE - Party in not unique in the Contract
3428: IF l_error_code = 'PARTY_NOT_UNIQUE' THEN
3429: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_NONUNIQUE_PARTY');
3430: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3431: VALUE => l_import_parties_rec.party_index);
3432: l_error_msg := fnd_message.get;
3433:

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

3426:
3427: --PARTY_NOT_UNIQUE - Party in not unique in the Contract
3428: IF l_error_code = 'PARTY_NOT_UNIQUE' THEN
3429: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_NONUNIQUE_PARTY');
3430: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3431: VALUE => l_import_parties_rec.party_index);
3432: l_error_msg := fnd_message.get;
3433:
3434: END IF;

Line 3432: l_error_msg := fnd_message.get;

3428: IF l_error_code = 'PARTY_NOT_UNIQUE' THEN
3429: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_NONUNIQUE_PARTY');
3430: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
3431: VALUE => l_import_parties_rec.party_index);
3432: l_error_msg := fnd_message.get;
3433:
3434: END IF;
3435:
3436: END IF;

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

3449: --Also populate the error table
3450: --Note that in this case we do not wait until the end to populate the error table
3451: --because this time the error type is 'CONTRACT' and not 'PARTY'.
3452: --The party may still be valid by itself.
3453: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_CON_TYPE');
3454: populate_import_errors(p_init_msg_list => FND_API.G_FALSE,
3455: p_api_version => 1.0,
3456: p_contract_id => l_import_parties_rec.imp_contract_id,
3457: p_error_obj_type => G_IMP_CONTRACT_ERROR,

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

3842: --contract_number has to be null
3843: --otherwise system should error out
3844: IF(l_import_contracts_rec.contract_number IS NOT NULL) THEN
3845: l_valid_flag := 'N';
3846: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_NONNULL_NUMBER');
3847: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3848: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3849: 'Auto number is turned on, but contract number is not null');
3850: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

3858: --contract_number is required
3859: --otherwise system should error out
3860: IF(l_import_contracts_rec.contract_number IS NULL) THEN
3861: l_valid_flag := 'N';
3862: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_NUMBER');
3863: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3864: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3865: 'Auto number is turned off, but contract number is missing');
3866: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

3872: --contract number is entered
3873: --we need to check for length
3874: IF(LENGTH(l_import_contracts_rec.contract_number) > l_contract_number_length) THEN
3875: l_valid_flag := 'N';
3876: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_NUMBER');
3877: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3878: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3879: 'Conract number is too long');
3880: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

3893: OPEN CONTRACT_NUMBER_UNIQUE_CSR(l_import_contracts_rec.contract_number, l_import_contracts_rec.imp_contract_id);
3894: FETCH CONTRACT_NUMBER_UNIQUE_CSR INTO l_unique_contract_number;
3895: IF CONTRACT_NUMBER_UNIQUE_CSR%FOUND THEN
3896: l_valid_flag := 'N';
3897: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_NONUNIQUE_NUMBER');
3898: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3899: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3900: 'Conract number is not unique');
3901: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

3914: 'Checking if user enters contract name');
3915: END IF;
3916: IF (l_valid_flag = 'Y' AND l_import_contracts_rec.contract_name IS NULL) THEN
3917: l_valid_flag := 'N';
3918: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_NAME');
3919: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3920: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3921: 'Contract Name is missing');
3922: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

3933: 'Checking if contract name is too long');
3934: END IF;
3935: IF (l_valid_flag = 'Y' AND LENGTH(l_import_contracts_rec.contract_name)>l_contract_name_length) THEN
3936: l_valid_flag := 'N';
3937: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_NAME');
3938: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3939: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3940: 'Contract Name is too long');
3941: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

3959: 'l_contract_intent: '||l_contract_intent);
3960: END IF;
3961: IF ((is_sales_workbench() = 'Y') AND (l_contract_intent = G_INTENT_BUY)) THEN
3962: l_valid_flag := 'N';
3963: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_SWB_INV_INTENT');
3964: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3965: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3966: 'Buy Intent Contract can not be imported in Sales Workbench ');
3967: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

3979: 'Checking if Original System Reference Code is too long');
3980: END IF;
3981: IF (l_valid_flag = 'Y' AND LENGTH(l_import_contracts_rec.orig_system_reference_code)>l_orig_system_code_length) THEN
3982: l_valid_flag := 'N';
3983: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_ORIG_CODE');
3984: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3985: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3986: 'Original System Reference Code is too long');
3987: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

3998: 'Checking if Original System ID1 is too long');
3999: END IF;
4000: IF (l_valid_flag = 'Y' AND LENGTH(l_import_contracts_rec.orig_system_reference_id1)>l_orig_system_id1_length) THEN
4001: l_valid_flag := 'N';
4002: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_ORIG_ID1');
4003: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4004: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4005: 'Original System ID1 is too long');
4006: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4017: 'Checking if Original System ID2 is too long');
4018: END IF;
4019: IF (l_valid_flag = 'Y' AND LENGTH(l_import_contracts_rec.orig_system_reference_id2)>l_orig_system_id2_length) THEN
4020: l_valid_flag := 'N';
4021: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_ORIG_ID2');
4022: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4023: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4024: 'Original System ID2 is too long');
4025: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4041: END IF;
4042:
4043: 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
4044: l_valid_flag := 'N';
4045: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_STATUS');
4046: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4047: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4048: 'Contract Status is missing');
4049: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4064: FETCH CONTRACT_STATUS_CSR INTO l_status_code;
4065: IF CONTRACT_STATUS_CSR%NOTFOUND THEN
4066: l_valid_flag := 'N';
4067: l_status_code := NULL;
4068: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_STATUS');
4069: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4070: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4071: 'Contract Status is invalid');
4072: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4089: l_import_contracts_rec.contract_type_txt := RTRIM(l_import_contracts_rec.contract_type_txt);
4090: END IF;
4091: 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
4092: l_valid_flag := 'N';
4093: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_CON_TYPE');
4094: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4095: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4096: 'Contract Type is missing');
4097: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4111: OPEN CONTRACT_TYPE_CSR(l_import_contracts_rec.contract_type_txt);
4112: FETCH CONTRACT_TYPE_CSR INTO l_contract_type;
4113: IF CONTRACT_TYPE_CSR%NOTFOUND THEN
4114: l_valid_flag := 'N';
4115: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_CON_TYPE');
4116: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4117: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4118: 'Contract Type is invalid');
4119: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4137: END IF;
4138:
4139: 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
4140: l_valid_flag := 'N';
4141: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_EFF_DATE');
4142: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4143: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4144: 'Contract Effective Date is missing');
4145: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4160: l_effective_date := to_date(l_import_contracts_rec.contract_effective_date, G_IMP_DATE_FORMAT);
4161: EXCEPTION
4162: WHEN OTHERS THEN
4163: l_valid_flag := 'N';
4164: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_EFF_DATE');
4165: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4166: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4167: 'Contract Effective Date is not valid');
4168: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4184: l_expiration_date := to_date(l_import_contracts_rec.contract_expiration_date, G_IMP_DATE_FORMAT);
4185: EXCEPTION
4186: WHEN OTHERS THEN
4187: l_valid_flag := 'N';
4188: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_EXP_DATE');
4189: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4190: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4191: 'Contract Expiration Date is not valid');
4192: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4209: --at this point if there are any errors regarding the date format we should have caught it
4210: --so it is safe to convert the dates
4211: 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
4212: l_valid_flag := 'N';
4213: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_EXP_BEFORE_EFF');
4214: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4215: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4216: 'Contract Expiration Date is before Contract Effective Date');
4217: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4233: l_import_contracts_rec.org_name := RTRIM(l_import_contracts_rec.org_name);
4234: END IF;
4235: IF (l_valid_flag = 'Y' AND (l_import_contracts_rec.org_name IS NULL OR LENGTH(l_import_contracts_rec.org_name)=0)) THEN
4236: l_valid_flag := 'N';
4237: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_ORG');
4238: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4239: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4240: 'Operating Unit is missing');
4241: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4255: OPEN ORG_NAME_CSR(l_import_contracts_rec.org_name);
4256: FETCH ORG_NAME_CSR INTO l_org_id;
4257: IF ORG_NAME_CSR%NOTFOUND THEN
4258: l_valid_flag := 'N';
4259: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_ORG');
4260: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4261: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4262: 'Operating Unit is invalid');
4263: 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_MISS_OWNER');

4280: l_import_contracts_rec.owner_user_name := RTRIM(l_import_contracts_rec.owner_user_name);
4281: END IF;
4282: 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
4283: l_valid_flag := 'N';
4284: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_OWNER');
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: 'Owner User Name is missing');
4288: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4303: OPEN OWNER_NAME_CSR(l_import_contracts_rec.owner_user_name);
4304: FETCH OWNER_NAME_CSR INTO l_owner_user_id;
4305: IF OWNER_NAME_CSR%NOTFOUND THEN
4306: l_valid_flag := 'N';
4307: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_OWNER');
4308: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4309: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4310: 'Owner User Name is invalid');
4311: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4330: IF (l_valid_flag = 'Y'
4331: AND l_import_contracts_rec.contract_amount IS NOT NULL
4332: AND (l_import_contracts_rec.currency_code IS NULL OR LENGTH(l_import_contracts_rec.currency_code)=0)) THEN
4333: l_valid_flag := 'N';
4334: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_MISS_CURRENCY');
4335: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4336: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4337: 'Owner User Name is missing');
4338: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4352: OPEN CURRENCY_CSR(l_import_contracts_rec.currency_code);
4353: FETCH CURRENCY_CSR INTO l_currency_code;
4354: IF CURRENCY_CSR%NOTFOUND THEN
4355: l_valid_flag := 'N';
4356: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_CURRENCY');
4357: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4358: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4359: 'Currency is invalid');
4360: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4377: l_amount := to_number(l_import_contracts_rec.contract_amount, G_IMP_NUMBER_FORMAT);
4378: EXCEPTION
4379: WHEN OTHERS THEN
4380: l_valid_flag := 'N';
4381: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_AMOUNT');
4382: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4383: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4384: 'Amount is not valid');
4385: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4402: OPEN AUTHORING_PARTY_CSR(l_import_contracts_rec.authoring_party_txt);
4403: FETCH AUTHORING_PARTY_CSR INTO l_authoring_party_code;
4404: IF AUTHORING_PARTY_CSR%NOTFOUND THEN
4405: l_valid_flag := 'N';
4406: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_AUTH_PARTY');
4407: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4408: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4409: 'Authoring Party is invalid');
4410: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4423: 'Checking if Physical Location is too long');
4424: END IF;
4425: IF (l_valid_flag = 'Y' AND LENGTH(l_import_contracts_rec.physical_location)>l_location_length) THEN
4426: l_valid_flag := 'N';
4427: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_LOCATION');
4428: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4429: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4430: 'Physical Location is too long');
4431: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4442: 'Checking if keywords is too long');
4443: END IF;
4444: IF (l_valid_flag = 'Y' AND LENGTH(l_import_contracts_rec.keywords)>l_keywords_length) THEN
4445: l_valid_flag := 'N';
4446: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_KEYWORDS');
4447: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4448: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4449: 'Keywords is too long');
4450: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4461: 'Checking if description is too long');
4462: END IF;
4463: IF (l_valid_flag = 'Y' AND LENGTH(l_import_contracts_rec.description)>l_description_length) THEN
4464: l_valid_flag := 'N';
4465: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_DESC');
4466: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4467: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4468: 'Description is too long');
4469: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4480: 'Checking if version comments is too long');
4481: END IF;
4482: IF (l_valid_flag = 'Y' AND LENGTH(l_import_contracts_rec.version_comments)>l_version_comments_length) THEN
4483: l_valid_flag := 'N';
4484: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_LONG_COMMENTS');
4485: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4486: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4487: 'Version Comments is too long');
4488: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4517: CLOSE CONTRACT_PARTIES_CSR;
4518:
4519: IF l_int_parties_count <> 1 THEN
4520: l_valid_flag := 'N';
4521: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_INT_PARTIES');
4522: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4523: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4524: 'There are not exactly one internal party');
4525: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

4530: ELSE
4531: --fix bug 4160416, need to validate internal party name with the org name in the header
4532: IF l_import_contracts_rec.org_name <> l_int_party_name THEN
4533: l_valid_flag := 'N';
4534: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_INT_PARTY_NAME');
4535: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4536: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4537: 'Internal party name and org name are not matching');
4538: 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_INV_EXT_PARTIES');

4544: END IF;
4545:
4546: IF l_ext_parties_count <1 THEN
4547: l_valid_flag := 'N';
4548: l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_INV_EXT_PARTIES');
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: 'There are less than one external party');
4552: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,