DBA Data[Home] [Help]

APPS.OE_EXT_CREDIT_EXPOSURE_PVT dependencies on FND_MESSAGE

Line 120: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_CURRENCY_INVALID');

116: >= TRUNC(SYSDATE) ;
117: EXCEPTION
118: WHEN NO_DATA_FOUND THEN
119: OE_DEBUG_PUB.Add('Validate Currency Failed - Invalid.', 5);
120: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_CURRENCY_INVALID');
121: FND_MESSAGE.SET_TOKEN ('COLUMN_NAME','CURRENCY_CODE');
122: FND_MESSAGE.SET_TOKEN ('COLUMN_VALUE', p_exposure_rec.currency_code);
123: l_message_text := FND_MESSAGE.GET;
124: OE_DEBUG_PUB.Add('Error: Currency invalid', 5);

Line 121: FND_MESSAGE.SET_TOKEN ('COLUMN_NAME','CURRENCY_CODE');

117: EXCEPTION
118: WHEN NO_DATA_FOUND THEN
119: OE_DEBUG_PUB.Add('Validate Currency Failed - Invalid.', 5);
120: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_CURRENCY_INVALID');
121: FND_MESSAGE.SET_TOKEN ('COLUMN_NAME','CURRENCY_CODE');
122: FND_MESSAGE.SET_TOKEN ('COLUMN_VALUE', p_exposure_rec.currency_code);
123: l_message_text := FND_MESSAGE.GET;
124: OE_DEBUG_PUB.Add('Error: Currency invalid', 5);
125: Insert_To_Errors_Table(

Line 122: FND_MESSAGE.SET_TOKEN ('COLUMN_VALUE', p_exposure_rec.currency_code);

118: WHEN NO_DATA_FOUND THEN
119: OE_DEBUG_PUB.Add('Validate Currency Failed - Invalid.', 5);
120: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_CURRENCY_INVALID');
121: FND_MESSAGE.SET_TOKEN ('COLUMN_NAME','CURRENCY_CODE');
122: FND_MESSAGE.SET_TOKEN ('COLUMN_VALUE', p_exposure_rec.currency_code);
123: l_message_text := FND_MESSAGE.GET;
124: OE_DEBUG_PUB.Add('Error: Currency invalid', 5);
125: Insert_To_Errors_Table(
126: p_exposure_source_code => p_exposure_rec.exposure_source_code

Line 123: l_message_text := FND_MESSAGE.GET;

119: OE_DEBUG_PUB.Add('Validate Currency Failed - Invalid.', 5);
120: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_CURRENCY_INVALID');
121: FND_MESSAGE.SET_TOKEN ('COLUMN_NAME','CURRENCY_CODE');
122: FND_MESSAGE.SET_TOKEN ('COLUMN_VALUE', p_exposure_rec.currency_code);
123: l_message_text := FND_MESSAGE.GET;
124: OE_DEBUG_PUB.Add('Error: Currency invalid', 5);
125: Insert_To_Errors_Table(
126: p_exposure_source_code => p_exposure_rec.exposure_source_code
127: , p_exposure_interface_id => p_exposure_rec.exposure_interface_id

Line 395: FND_MESSAGE.SET_NAME('ONT','OE_CC_IMP_BILL_TO_ADDR_INVALID');

391: IF C2%ISOPEN then
392: CLOSE C2;
393: END IF;
394:
395: FND_MESSAGE.SET_NAME('ONT','OE_CC_IMP_BILL_TO_ADDR_INVALID');
396: l_message_text := FND_MESSAGE.Get;
397: OE_DEBUG_PUB.Add('Error: No valid address found', 5);
398: Insert_To_Errors_Table(
399: p_exposure_source_code => p_exposure_rec.exposure_source_code

Line 396: l_message_text := FND_MESSAGE.Get;

392: CLOSE C2;
393: END IF;
394:
395: FND_MESSAGE.SET_NAME('ONT','OE_CC_IMP_BILL_TO_ADDR_INVALID');
396: l_message_text := FND_MESSAGE.Get;
397: OE_DEBUG_PUB.Add('Error: No valid address found', 5);
398: Insert_To_Errors_Table(
399: p_exposure_source_code => p_exposure_rec.exposure_source_code
400: , p_exposure_interface_id => p_exposure_rec.exposure_interface_id

Line 421: FND_MESSAGE.SET_NAME('ONT','OE_CC_IMP_BILL_TO_ADDR_MULTI');

417: IF C2%ISOPEN then
418: CLOSE C2;
419: END IF;
420:
421: FND_MESSAGE.SET_NAME('ONT','OE_CC_IMP_BILL_TO_ADDR_MULTI');
422: l_message_text := FND_MESSAGE.Get;
423: OE_DEBUG_PUB.Add('Error: Found multiple addresses', 5);
424: Insert_To_Errors_Table(
425: p_exposure_source_code => p_exposure_rec.exposure_source_code

Line 422: l_message_text := FND_MESSAGE.Get;

418: CLOSE C2;
419: END IF;
420:
421: FND_MESSAGE.SET_NAME('ONT','OE_CC_IMP_BILL_TO_ADDR_MULTI');
422: l_message_text := FND_MESSAGE.Get;
423: OE_DEBUG_PUB.Add('Error: Found multiple addresses', 5);
424: Insert_To_Errors_Table(
425: p_exposure_source_code => p_exposure_rec.exposure_source_code
426: , p_exposure_interface_id => p_exposure_rec.exposure_interface_id

Line 501: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_SITE_USE_ID_INVALID');

497: WHEN NO_DATA_FOUND THEN
498: -- This same error message takes care of the case of NULL value
499: -- passed in since a NULL in the select will not select any rows.
500: x_return_status := FND_API.G_RET_STS_ERROR;
501: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_SITE_USE_ID_INVALID');
502: FND_MESSAGE.Set_Token('COLUMN_NAME' , 'BILL_TO_SITE_USE_ID');
503: FND_MESSAGE.Set_Token('COLUMN_VALUE', p_exposure_rec.bill_to_site_use_id);
504: l_message_text := FND_MESSAGE.Get;
505: OE_DEBUG_PUB.Add('Error: Bill-to site use ID invalid', 5);

Line 502: FND_MESSAGE.Set_Token('COLUMN_NAME' , 'BILL_TO_SITE_USE_ID');

498: -- This same error message takes care of the case of NULL value
499: -- passed in since a NULL in the select will not select any rows.
500: x_return_status := FND_API.G_RET_STS_ERROR;
501: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_SITE_USE_ID_INVALID');
502: FND_MESSAGE.Set_Token('COLUMN_NAME' , 'BILL_TO_SITE_USE_ID');
503: FND_MESSAGE.Set_Token('COLUMN_VALUE', p_exposure_rec.bill_to_site_use_id);
504: l_message_text := FND_MESSAGE.Get;
505: OE_DEBUG_PUB.Add('Error: Bill-to site use ID invalid', 5);
506: Insert_To_Errors_Table(

Line 503: FND_MESSAGE.Set_Token('COLUMN_VALUE', p_exposure_rec.bill_to_site_use_id);

499: -- passed in since a NULL in the select will not select any rows.
500: x_return_status := FND_API.G_RET_STS_ERROR;
501: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_SITE_USE_ID_INVALID');
502: FND_MESSAGE.Set_Token('COLUMN_NAME' , 'BILL_TO_SITE_USE_ID');
503: FND_MESSAGE.Set_Token('COLUMN_VALUE', p_exposure_rec.bill_to_site_use_id);
504: l_message_text := FND_MESSAGE.Get;
505: OE_DEBUG_PUB.Add('Error: Bill-to site use ID invalid', 5);
506: Insert_To_Errors_Table(
507: p_exposure_source_code => p_exposure_rec.exposure_source_code

Line 504: l_message_text := FND_MESSAGE.Get;

500: x_return_status := FND_API.G_RET_STS_ERROR;
501: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_SITE_USE_ID_INVALID');
502: FND_MESSAGE.Set_Token('COLUMN_NAME' , 'BILL_TO_SITE_USE_ID');
503: FND_MESSAGE.Set_Token('COLUMN_VALUE', p_exposure_rec.bill_to_site_use_id);
504: l_message_text := FND_MESSAGE.Get;
505: OE_DEBUG_PUB.Add('Error: Bill-to site use ID invalid', 5);
506: Insert_To_Errors_Table(
507: p_exposure_source_code => p_exposure_rec.exposure_source_code
508: , p_exposure_interface_id => p_exposure_rec.exposure_interface_id

Line 562: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_CUST_INFO_INVALID');

558: END IF;
559: EXCEPTION
560: WHEN NO_DATA_FOUND THEN
561: x_return_status := FND_API.G_RET_STS_ERROR;
562: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_CUST_INFO_INVALID');
563: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NAME', 'BILL_TO_CUSTOMER_NAME' );
564: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NUMBER', 'BILL_TO_CUSTOMER_NUMBER' );
565: l_message_text := FND_MESSAGE.Get;
566: OE_DEBUG_PUB.Add('Error: Customer ID cannot be derived from customer name and number', 5);

Line 563: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NAME', 'BILL_TO_CUSTOMER_NAME' );

559: EXCEPTION
560: WHEN NO_DATA_FOUND THEN
561: x_return_status := FND_API.G_RET_STS_ERROR;
562: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_CUST_INFO_INVALID');
563: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NAME', 'BILL_TO_CUSTOMER_NAME' );
564: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NUMBER', 'BILL_TO_CUSTOMER_NUMBER' );
565: l_message_text := FND_MESSAGE.Get;
566: OE_DEBUG_PUB.Add('Error: Customer ID cannot be derived from customer name and number', 5);
567: Insert_To_Errors_Table(

Line 564: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NUMBER', 'BILL_TO_CUSTOMER_NUMBER' );

560: WHEN NO_DATA_FOUND THEN
561: x_return_status := FND_API.G_RET_STS_ERROR;
562: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_CUST_INFO_INVALID');
563: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NAME', 'BILL_TO_CUSTOMER_NAME' );
564: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NUMBER', 'BILL_TO_CUSTOMER_NUMBER' );
565: l_message_text := FND_MESSAGE.Get;
566: OE_DEBUG_PUB.Add('Error: Customer ID cannot be derived from customer name and number', 5);
567: Insert_To_Errors_Table(
568: p_exposure_source_code => p_exposure_rec.exposure_source_code

Line 565: l_message_text := FND_MESSAGE.Get;

561: x_return_status := FND_API.G_RET_STS_ERROR;
562: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_CUST_INFO_INVALID');
563: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NAME', 'BILL_TO_CUSTOMER_NAME' );
564: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NUMBER', 'BILL_TO_CUSTOMER_NUMBER' );
565: l_message_text := FND_MESSAGE.Get;
566: OE_DEBUG_PUB.Add('Error: Customer ID cannot be derived from customer name and number', 5);
567: Insert_To_Errors_Table(
568: p_exposure_source_code => p_exposure_rec.exposure_source_code
569: , p_exposure_interface_id => p_exposure_rec.exposure_interface_id

Line 578: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_CUST_INFO_MISSING');

574: END;
575: ELSE
576: -- customer information is missing
577: x_return_status := FND_API.G_RET_STS_ERROR;
578: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_CUST_INFO_MISSING');
579: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NAME', 'BILL_TO_CUSTOMER_NAME' );
580: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NUMBER', 'BILL_TO_CUSTOMER_NUMBER' );
581: FND_MESSAGE.SET_TOKEN ('CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID');
582: l_message_text := FND_MESSAGE.Get;

Line 579: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NAME', 'BILL_TO_CUSTOMER_NAME' );

575: ELSE
576: -- customer information is missing
577: x_return_status := FND_API.G_RET_STS_ERROR;
578: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_CUST_INFO_MISSING');
579: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NAME', 'BILL_TO_CUSTOMER_NAME' );
580: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NUMBER', 'BILL_TO_CUSTOMER_NUMBER' );
581: FND_MESSAGE.SET_TOKEN ('CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID');
582: l_message_text := FND_MESSAGE.Get;
583: OE_DEBUG_PUB.Add('Error: No customer information provided', 5);

Line 580: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NUMBER', 'BILL_TO_CUSTOMER_NUMBER' );

576: -- customer information is missing
577: x_return_status := FND_API.G_RET_STS_ERROR;
578: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_CUST_INFO_MISSING');
579: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NAME', 'BILL_TO_CUSTOMER_NAME' );
580: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NUMBER', 'BILL_TO_CUSTOMER_NUMBER' );
581: FND_MESSAGE.SET_TOKEN ('CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID');
582: l_message_text := FND_MESSAGE.Get;
583: OE_DEBUG_PUB.Add('Error: No customer information provided', 5);
584: Insert_To_Errors_Table(

Line 581: FND_MESSAGE.SET_TOKEN ('CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID');

577: x_return_status := FND_API.G_RET_STS_ERROR;
578: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_CUST_INFO_MISSING');
579: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NAME', 'BILL_TO_CUSTOMER_NAME' );
580: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NUMBER', 'BILL_TO_CUSTOMER_NUMBER' );
581: FND_MESSAGE.SET_TOKEN ('CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID');
582: l_message_text := FND_MESSAGE.Get;
583: OE_DEBUG_PUB.Add('Error: No customer information provided', 5);
584: Insert_To_Errors_Table(
585: p_exposure_source_code => p_exposure_rec.exposure_source_code

Line 582: l_message_text := FND_MESSAGE.Get;

578: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_CUST_INFO_MISSING');
579: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NAME', 'BILL_TO_CUSTOMER_NAME' );
580: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NUMBER', 'BILL_TO_CUSTOMER_NUMBER' );
581: FND_MESSAGE.SET_TOKEN ('CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID');
582: l_message_text := FND_MESSAGE.Get;
583: OE_DEBUG_PUB.Add('Error: No customer information provided', 5);
584: Insert_To_Errors_Table(
585: p_exposure_source_code => p_exposure_rec.exposure_source_code
586: , p_exposure_interface_id => p_exposure_rec.exposure_interface_id

Line 597: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_SITE_USE_INF_INVALID');

593: ELSE
594: -- insufficient information is provided to derive the invoice site use id.
595: -- Either the bill_to site use ID needs to be provided or the bill-to address.
596: x_return_status := FND_API.G_RET_STS_ERROR;
597: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_SITE_USE_INF_INVALID');
598: l_message_text := FND_MESSAGE.Get;
599: OE_DEBUG_PUB.Add('Error: Insufficient information provided to derive site use ID', 5);
600:
601: Insert_To_Errors_Table(

Line 598: l_message_text := FND_MESSAGE.Get;

594: -- insufficient information is provided to derive the invoice site use id.
595: -- Either the bill_to site use ID needs to be provided or the bill-to address.
596: x_return_status := FND_API.G_RET_STS_ERROR;
597: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_SITE_USE_INF_INVALID');
598: l_message_text := FND_MESSAGE.Get;
599: OE_DEBUG_PUB.Add('Error: Insufficient information provided to derive site use ID', 5);
600:
601: Insert_To_Errors_Table(
602: p_exposure_source_code => p_exposure_rec.exposure_source_code

Line 684: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_SOURCE_INVALID');

680: >= TRUNC(SYSDATE) ;
681: EXCEPTION
682: WHEN NO_DATA_FOUND THEN
683: -- exposure source code is not valid
684: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_SOURCE_INVALID');
685: FND_MESSAGE.Set_Token ('COLUMN_NAME','EXPOSURE_SOURCE_CODE');
686: FND_MESSAGE.Set_Token ('COLUMN_VALUE', l_row.exposure_source_code);
687: l_message_text := FND_MESSAGE.Get;
688: OE_DEBUG_PUB.Add('Error: Exposure source code is not valid', 2);

Line 685: FND_MESSAGE.Set_Token ('COLUMN_NAME','EXPOSURE_SOURCE_CODE');

681: EXCEPTION
682: WHEN NO_DATA_FOUND THEN
683: -- exposure source code is not valid
684: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_SOURCE_INVALID');
685: FND_MESSAGE.Set_Token ('COLUMN_NAME','EXPOSURE_SOURCE_CODE');
686: FND_MESSAGE.Set_Token ('COLUMN_VALUE', l_row.exposure_source_code);
687: l_message_text := FND_MESSAGE.Get;
688: OE_DEBUG_PUB.Add('Error: Exposure source code is not valid', 2);
689: Insert_To_Errors_Table(

Line 686: FND_MESSAGE.Set_Token ('COLUMN_VALUE', l_row.exposure_source_code);

682: WHEN NO_DATA_FOUND THEN
683: -- exposure source code is not valid
684: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_SOURCE_INVALID');
685: FND_MESSAGE.Set_Token ('COLUMN_NAME','EXPOSURE_SOURCE_CODE');
686: FND_MESSAGE.Set_Token ('COLUMN_VALUE', l_row.exposure_source_code);
687: l_message_text := FND_MESSAGE.Get;
688: OE_DEBUG_PUB.Add('Error: Exposure source code is not valid', 2);
689: Insert_To_Errors_Table(
690: p_exposure_source_code => l_row.exposure_source_code

Line 687: l_message_text := FND_MESSAGE.Get;

683: -- exposure source code is not valid
684: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_SOURCE_INVALID');
685: FND_MESSAGE.Set_Token ('COLUMN_NAME','EXPOSURE_SOURCE_CODE');
686: FND_MESSAGE.Set_Token ('COLUMN_VALUE', l_row.exposure_source_code);
687: l_message_text := FND_MESSAGE.Get;
688: OE_DEBUG_PUB.Add('Error: Exposure source code is not valid', 2);
689: Insert_To_Errors_Table(
690: p_exposure_source_code => l_row.exposure_source_code
691: , p_exposure_interface_id => NULL

Line 714: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_OP_CODE_MULTIPLE');

710: OE_DEBUG_PUB.Add('Exposure source code '||l_row.exposure_source_code||
711: ' contains multiple operation codes', 2);
712: -- write message to errors table
713: l_any_op_code_errors := TRUE;
714: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_OP_CODE_MULTIPLE');
715: l_message_text := FND_MESSAGE.Get;
716: OE_DEBUG_PUB.Add('Error: Exposure source contains multiple operation codes', 2);
717: ELSE
718: OE_DEBUG_PUB.Add('Exposure source code '||l_row.exposure_source_code||

Line 715: l_message_text := FND_MESSAGE.Get;

711: ' contains multiple operation codes', 2);
712: -- write message to errors table
713: l_any_op_code_errors := TRUE;
714: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_OP_CODE_MULTIPLE');
715: l_message_text := FND_MESSAGE.Get;
716: OE_DEBUG_PUB.Add('Error: Exposure source contains multiple operation codes', 2);
717: ELSE
718: OE_DEBUG_PUB.Add('Exposure source code '||l_row.exposure_source_code||
719: ' contains 1 operation code', 2);

Line 728: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_OP_CODE_MULTIPLE');

724: l_any_op_code_errors := TRUE;
725: OE_DEBUG_PUB.Add('Exposure source code '||l_row.exposure_source_code||
726: ' contains an invalid operation code', 2);
727: -- write message to errors table
728: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_OP_CODE_MULTIPLE');
729: l_message_text := FND_MESSAGE.Get;
730: END IF;
731: CLOSE c_invalid_op_code;
732: END IF;

Line 729: l_message_text := FND_MESSAGE.Get;

725: OE_DEBUG_PUB.Add('Exposure source code '||l_row.exposure_source_code||
726: ' contains an invalid operation code', 2);
727: -- write message to errors table
728: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_OP_CODE_MULTIPLE');
729: l_message_text := FND_MESSAGE.Get;
730: END IF;
731: CLOSE c_invalid_op_code;
732: END IF;
733: CLOSE c_multi_op_code;

Line 1163: FND_MESSAGE.Set_Name('ONT', 'OE_CC_API_VERSION_MISMATCH');

1159: l_api_name,
1160: G_PKG_NAME)
1161: THEN
1162: FND_MSG_PUB.Delete_Msg;
1163: FND_MESSAGE.Set_Name('ONT', 'OE_CC_API_VERSION_MISMATCH');
1164: FND_MESSAGE.SET_TOKEN ('API_NAME', l_api_name );
1165: FND_MESSAGE.SET_TOKEN ('P_API_VERSION', p_api_version );
1166: FND_MESSAGE.SET_TOKEN ('CURR_VER_NUM',l_api_version);
1167: FND_MESSAGE.SET_TOKEN ('CALLER_VER_NUM',p_api_version);

Line 1164: FND_MESSAGE.SET_TOKEN ('API_NAME', l_api_name );

1160: G_PKG_NAME)
1161: THEN
1162: FND_MSG_PUB.Delete_Msg;
1163: FND_MESSAGE.Set_Name('ONT', 'OE_CC_API_VERSION_MISMATCH');
1164: FND_MESSAGE.SET_TOKEN ('API_NAME', l_api_name );
1165: FND_MESSAGE.SET_TOKEN ('P_API_VERSION', p_api_version );
1166: FND_MESSAGE.SET_TOKEN ('CURR_VER_NUM',l_api_version);
1167: FND_MESSAGE.SET_TOKEN ('CALLER_VER_NUM',p_api_version);
1168: OE_DEBUG_PUB.Add('l_api_version: '||l_api_version);

Line 1165: FND_MESSAGE.SET_TOKEN ('P_API_VERSION', p_api_version );

1161: THEN
1162: FND_MSG_PUB.Delete_Msg;
1163: FND_MESSAGE.Set_Name('ONT', 'OE_CC_API_VERSION_MISMATCH');
1164: FND_MESSAGE.SET_TOKEN ('API_NAME', l_api_name );
1165: FND_MESSAGE.SET_TOKEN ('P_API_VERSION', p_api_version );
1166: FND_MESSAGE.SET_TOKEN ('CURR_VER_NUM',l_api_version);
1167: FND_MESSAGE.SET_TOKEN ('CALLER_VER_NUM',p_api_version);
1168: OE_DEBUG_PUB.Add('l_api_version: '||l_api_version);
1169: OE_DEBUG_PUB.Add('p_api_version: '||p_api_version);

Line 1166: FND_MESSAGE.SET_TOKEN ('CURR_VER_NUM',l_api_version);

1162: FND_MSG_PUB.Delete_Msg;
1163: FND_MESSAGE.Set_Name('ONT', 'OE_CC_API_VERSION_MISMATCH');
1164: FND_MESSAGE.SET_TOKEN ('API_NAME', l_api_name );
1165: FND_MESSAGE.SET_TOKEN ('P_API_VERSION', p_api_version );
1166: FND_MESSAGE.SET_TOKEN ('CURR_VER_NUM',l_api_version);
1167: FND_MESSAGE.SET_TOKEN ('CALLER_VER_NUM',p_api_version);
1168: OE_DEBUG_PUB.Add('l_api_version: '||l_api_version);
1169: OE_DEBUG_PUB.Add('p_api_version: '||p_api_version);
1170: OE_DEBUG_PUB.Add('API Version Check Failed.');

Line 1167: FND_MESSAGE.SET_TOKEN ('CALLER_VER_NUM',p_api_version);

1163: FND_MESSAGE.Set_Name('ONT', 'OE_CC_API_VERSION_MISMATCH');
1164: FND_MESSAGE.SET_TOKEN ('API_NAME', l_api_name );
1165: FND_MESSAGE.SET_TOKEN ('P_API_VERSION', p_api_version );
1166: FND_MESSAGE.SET_TOKEN ('CURR_VER_NUM',l_api_version);
1167: FND_MESSAGE.SET_TOKEN ('CALLER_VER_NUM',p_api_version);
1168: OE_DEBUG_PUB.Add('l_api_version: '||l_api_version);
1169: OE_DEBUG_PUB.Add('p_api_version: '||p_api_version);
1170: OE_DEBUG_PUB.Add('API Version Check Failed.');
1171: l_message_text := FND_MESSAGE.GET;

Line 1171: l_message_text := FND_MESSAGE.GET;

1167: FND_MESSAGE.SET_TOKEN ('CALLER_VER_NUM',p_api_version);
1168: OE_DEBUG_PUB.Add('l_api_version: '||l_api_version);
1169: OE_DEBUG_PUB.Add('p_api_version: '||p_api_version);
1170: OE_DEBUG_PUB.Add('API Version Check Failed.');
1171: l_message_text := FND_MESSAGE.GET;
1172: OE_DEBUG_PUB.Add('message text: '||SUBSTRB(l_message_text, 1, 200));
1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1174: END IF;
1175: