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.OE_INLINE_CUSTOMER_PUB dependencies on FND_MESSAGE

Line 82: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');

78: END IF;
79: IF l_debug_level > 0 THEN
80: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
81: END IF;
82: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
83: fnd_message.set_token('API_NAME', 'Initialize_Global');
84: oe_msg_pub.add;
85: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
86: IF l_debug_level > 0 THEN

Line 83: fnd_message.set_token('API_NAME', 'Initialize_Global');

79: IF l_debug_level > 0 THEN
80: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
81: END IF;
82: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
83: fnd_message.set_token('API_NAME', 'Initialize_Global');
84: oe_msg_pub.add;
85: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
86: IF l_debug_level > 0 THEN
87: oe_debug_pub.add( 'EXITING PROCEDURE INITIALIZE_GLOBAL' ) ;

Line 140: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');

136: END IF;
137: IF l_debug_level > 0 THEN
138: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
139: END IF;
140: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
141: fnd_message.set_token('API_NAME', 'Validate_Party_Number');
142: oe_msg_pub.add;
143: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
144: IF l_debug_level > 0 THEN

Line 141: fnd_message.set_token('API_NAME', 'Validate_Party_Number');

137: IF l_debug_level > 0 THEN
138: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
139: END IF;
140: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
141: fnd_message.set_token('API_NAME', 'Validate_Party_Number');
142: oe_msg_pub.add;
143: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
144: IF l_debug_level > 0 THEN
145: oe_debug_pub.add( 'EXITING VALIDATE PARTY NUMBER API WITHOUT PARTY ID' ) ;

Line 345: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');

341: IF l_debug_level > 0 THEN
342: oe_debug_pub.add( 'PROBLEM IN CALL TO CREATE_CUST_RELATIONSHIP. ABORT PROCESSING' ) ;
343: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
344: END IF;
345: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
346: fnd_message.set_token('API_NAME', 'Create_Cust_Relationship');
347: oe_msg_pub.add;
348: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
349: IF l_debug_level > 0 THEN

Line 346: fnd_message.set_token('API_NAME', 'Create_Cust_Relationship');

342: oe_debug_pub.add( 'PROBLEM IN CALL TO CREATE_CUST_RELATIONSHIP. ABORT PROCESSING' ) ;
343: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
344: END IF;
345: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
346: fnd_message.set_token('API_NAME', 'Create_Cust_Relationship');
347: oe_msg_pub.add;
348: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
349: IF l_debug_level > 0 THEN
350: oe_debug_pub.add( 'EXITING CREATE_CUST_RELATIONSHIP API WITH ERROR' ) ;

Line 535: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');

531: END IF;
532: IF l_debug_level > 0 THEN
533: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
534: END IF;
535: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
536: fnd_message.set_token('API_NAME', 'Check_and_Create_Contact');
537: oe_msg_pub.add;
538: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
539: IF l_debug_level > 0 THEN

Line 536: fnd_message.set_token('API_NAME', 'Check_and_Create_Contact');

532: IF l_debug_level > 0 THEN
533: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
534: END IF;
535: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
536: fnd_message.set_token('API_NAME', 'Check_and_Create_Contact');
537: oe_msg_pub.add;
538: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
539: IF l_debug_level > 0 THEN
540: oe_debug_pub.add( 'EXITING CHECK AND CREATE AND CREATE CONTACT API' ) ;

Line 682: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');

678: END IF;
679: IF l_debug_level > 0 THEN
680: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
681: END IF;
682: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
683: fnd_message.set_token('API_NAME', 'Create_Contact_Point');
684: oe_msg_pub.add;
685: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
686: IF l_debug_level > 0 THEN

Line 683: fnd_message.set_token('API_NAME', 'Create_Contact_Point');

679: IF l_debug_level > 0 THEN
680: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
681: END IF;
682: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
683: fnd_message.set_token('API_NAME', 'Create_Contact_Point');
684: oe_msg_pub.add;
685: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
686: IF l_debug_level > 0 THEN
687: oe_debug_pub.add( 'EXITING CREATE CONTACT POINT API WITH ERROR' ) ;

Line 870: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');

866: -- Raise Error and Abort Processing
867: IF l_debug_level > 0 THEN
868: oe_debug_pub.add( 'TRYING TO ENTER THE ACCOUNT WHICH ALREADY EXISTS' ) ;
869: END IF;
870: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
871: fnd_message.set_token('TYPE', 'ACCOUNT');
872: fnd_message.set_token('REFERENCE', p_customer_info_ref);
873: oe_msg_pub.add;
874: x_return_status := FND_API.G_RET_STS_ERROR;

Line 871: fnd_message.set_token('TYPE', 'ACCOUNT');

867: IF l_debug_level > 0 THEN
868: oe_debug_pub.add( 'TRYING TO ENTER THE ACCOUNT WHICH ALREADY EXISTS' ) ;
869: END IF;
870: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
871: fnd_message.set_token('TYPE', 'ACCOUNT');
872: fnd_message.set_token('REFERENCE', p_customer_info_ref);
873: oe_msg_pub.add;
874: x_return_status := FND_API.G_RET_STS_ERROR;
875: Update_Error_Flag(p_rowid => customer_rec.rowid);

Line 872: fnd_message.set_token('REFERENCE', p_customer_info_ref);

868: oe_debug_pub.add( 'TRYING TO ENTER THE ACCOUNT WHICH ALREADY EXISTS' ) ;
869: END IF;
870: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
871: fnd_message.set_token('TYPE', 'ACCOUNT');
872: fnd_message.set_token('REFERENCE', p_customer_info_ref);
873: oe_msg_pub.add;
874: x_return_status := FND_API.G_RET_STS_ERROR;
875: Update_Error_Flag(p_rowid => customer_rec.rowid);
876: Return;

Line 892: fnd_message.set_name('ONT','ONT_OI_INL_REQD');

888: -- Raise Error and Abort Processing
889: IF l_debug_level > 0 THEN
890: oe_debug_pub.add( 'EMAIL REQUIRED BUT NOT ENTERED' ) ;
891: END IF;
892: fnd_message.set_name('ONT','ONT_OI_INL_REQD');
893: fnd_message.set_token('API_NAME', 'Create_Account');
894: fnd_message.set_token('FIELD_REQD', 'EMAIL_ADDRESS');
895: oe_msg_pub.add;
896: x_return_status := FND_API.G_RET_STS_ERROR;

Line 893: fnd_message.set_token('API_NAME', 'Create_Account');

889: IF l_debug_level > 0 THEN
890: oe_debug_pub.add( 'EMAIL REQUIRED BUT NOT ENTERED' ) ;
891: END IF;
892: fnd_message.set_name('ONT','ONT_OI_INL_REQD');
893: fnd_message.set_token('API_NAME', 'Create_Account');
894: fnd_message.set_token('FIELD_REQD', 'EMAIL_ADDRESS');
895: oe_msg_pub.add;
896: x_return_status := FND_API.G_RET_STS_ERROR;
897: Update_Error_Flag(p_rowid => customer_rec.rowid);

Line 894: fnd_message.set_token('FIELD_REQD', 'EMAIL_ADDRESS');

890: oe_debug_pub.add( 'EMAIL REQUIRED BUT NOT ENTERED' ) ;
891: END IF;
892: fnd_message.set_name('ONT','ONT_OI_INL_REQD');
893: fnd_message.set_token('API_NAME', 'Create_Account');
894: fnd_message.set_token('FIELD_REQD', 'EMAIL_ADDRESS');
895: oe_msg_pub.add;
896: x_return_status := FND_API.G_RET_STS_ERROR;
897: Update_Error_Flag(p_rowid => customer_rec.rowid);
898: End If; -- If G_EMAIL_REQUIRED

Line 906: fnd_message.set_name('ONT','ONT_OI_INL_REQD');

902: -- Raise Error and Abort Processing
903: IF l_debug_level > 0 THEN
904: oe_debug_pub.add( 'PARTY NUMBER REQUIRED BUT NOT ENTERED' ) ;
905: END IF;
906: fnd_message.set_name('ONT','ONT_OI_INL_REQD');
907: fnd_message.set_token('API_NAME', 'Create_Account');
908: fnd_message.set_token('FIELD_REQD', 'PARTY_NUMBER');
909: oe_msg_pub.add;
910: x_return_status := FND_API.G_RET_STS_ERROR;

Line 907: fnd_message.set_token('API_NAME', 'Create_Account');

903: IF l_debug_level > 0 THEN
904: oe_debug_pub.add( 'PARTY NUMBER REQUIRED BUT NOT ENTERED' ) ;
905: END IF;
906: fnd_message.set_name('ONT','ONT_OI_INL_REQD');
907: fnd_message.set_token('API_NAME', 'Create_Account');
908: fnd_message.set_token('FIELD_REQD', 'PARTY_NUMBER');
909: oe_msg_pub.add;
910: x_return_status := FND_API.G_RET_STS_ERROR;
911: Update_Error_Flag(p_rowid => customer_rec.rowid);

Line 908: fnd_message.set_token('FIELD_REQD', 'PARTY_NUMBER');

904: oe_debug_pub.add( 'PARTY NUMBER REQUIRED BUT NOT ENTERED' ) ;
905: END IF;
906: fnd_message.set_name('ONT','ONT_OI_INL_REQD');
907: fnd_message.set_token('API_NAME', 'Create_Account');
908: fnd_message.set_token('FIELD_REQD', 'PARTY_NUMBER');
909: oe_msg_pub.add;
910: x_return_status := FND_API.G_RET_STS_ERROR;
911: Update_Error_Flag(p_rowid => customer_rec.rowid);
912: End If; -- If G_AUTO_PARTY_NUMBERING

Line 920: fnd_message.set_name('ONT','ONT_OI_INL_REQD');

916: -- Raise Error and Abort Processing
917: IF l_debug_level > 0 THEN
918: oe_debug_pub.add( 'CUSTOMER NUMBER REQUIRED BUT NOT ENTERED' ) ;
919: END IF;
920: fnd_message.set_name('ONT','ONT_OI_INL_REQD');
921: fnd_message.set_token('API_NAME', 'Create_Account');
922: fnd_message.set_token('FIELD_REQD', 'CUSTOMER_NUMBER');
923: oe_msg_pub.add;
924: x_return_status := FND_API.G_RET_STS_ERROR;

Line 921: fnd_message.set_token('API_NAME', 'Create_Account');

917: IF l_debug_level > 0 THEN
918: oe_debug_pub.add( 'CUSTOMER NUMBER REQUIRED BUT NOT ENTERED' ) ;
919: END IF;
920: fnd_message.set_name('ONT','ONT_OI_INL_REQD');
921: fnd_message.set_token('API_NAME', 'Create_Account');
922: fnd_message.set_token('FIELD_REQD', 'CUSTOMER_NUMBER');
923: oe_msg_pub.add;
924: x_return_status := FND_API.G_RET_STS_ERROR;
925: Update_Error_Flag(p_rowid => customer_rec.rowid);

Line 922: fnd_message.set_token('FIELD_REQD', 'CUSTOMER_NUMBER');

918: oe_debug_pub.add( 'CUSTOMER NUMBER REQUIRED BUT NOT ENTERED' ) ;
919: END IF;
920: fnd_message.set_name('ONT','ONT_OI_INL_REQD');
921: fnd_message.set_token('API_NAME', 'Create_Account');
922: fnd_message.set_token('FIELD_REQD', 'CUSTOMER_NUMBER');
923: oe_msg_pub.add;
924: x_return_status := FND_API.G_RET_STS_ERROR;
925: Update_Error_Flag(p_rowid => customer_rec.rowid);
926: End If; -- If G_AUTO_CUST_NUMBERING

Line 961: fnd_message.set_name('ONT','ONT_OI_INL_BOTH_PARTY_CUST');

957:
958: IF l_debug_level > 0 THEN
959: oe_debug_pub.add( 'BOTH PERSON AND ORGANIZATION INFORMATION CAN NOT BE POPULATED TOGETHER , POPULATE WHAT YOU ARE CREATING' ) ;
960: END IF;
961: fnd_message.set_name('ONT','ONT_OI_INL_BOTH_PARTY_CUST');
962: oe_msg_pub.add;
963: x_return_status := FND_API.G_RET_STS_ERROR;
964: IF l_debug_level > 0 THEN
965: oe_debug_pub.add( 'EXITING IN CREATE_ACCOUNT PROCEDURE WITH ERROR' ) ;

Line 1356: fnd_message.set_name('ONT','ONT_OI_INL_INV_CUST_TYPE');

1352: IF l_debug_level > 0 THEN
1353: oe_debug_pub.add( 'WRONG TYPE OF CUSTOMER INFORMATION PASSED.' ) ;
1354: END IF;
1355: x_return_status := FND_API.G_RET_STS_ERROR;
1356: fnd_message.set_name('ONT','ONT_OI_INL_INV_CUST_TYPE');
1357: oe_msg_pub.add;
1358: IF l_debug_level > 0 THEN
1359: oe_debug_pub.add( 'EXITING IN CREATE_ACCOUNT PROCEDURE WITH ERROR' ) ;
1360: END IF;

Line 1376: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');

1372: END IF;
1373: IF l_debug_level > 0 THEN
1374: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
1375: END IF;
1376: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
1377: fnd_message.set_token('API_NAME', 'Create_Account');
1378: oe_msg_pub.add;
1379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1380: Update_Error_Flag(p_rowid => customer_rec.rowid);

Line 1377: fnd_message.set_token('API_NAME', 'Create_Account');

1373: IF l_debug_level > 0 THEN
1374: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
1375: END IF;
1376: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
1377: fnd_message.set_token('API_NAME', 'Create_Account');
1378: oe_msg_pub.add;
1379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1380: Update_Error_Flag(p_rowid => customer_rec.rowid);
1381: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);

Line 1393: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');

1389: If l_no_record_exists Then
1390: IF l_debug_level > 0 THEN
1391: oe_debug_pub.add( 'NO RECORD FOUND FOR THE PASSED REF , PLEASE CHECK DATA' ) ;
1392: END IF;
1393: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');
1394: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1395: oe_msg_pub.add;
1396: x_return_status := FND_API.G_RET_STS_ERROR;
1397: IF l_debug_level > 0 THEN

Line 1394: fnd_message.set_token('REFERENCE', p_customer_info_ref);

1390: IF l_debug_level > 0 THEN
1391: oe_debug_pub.add( 'NO RECORD FOUND FOR THE PASSED REF , PLEASE CHECK DATA' ) ;
1392: END IF;
1393: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');
1394: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1395: oe_msg_pub.add;
1396: x_return_status := FND_API.G_RET_STS_ERROR;
1397: IF l_debug_level > 0 THEN
1398: oe_debug_pub.add( 'EXITING IN CREATE_ACCOUNT PROCEDURE WITH ERROR' ) ;

Line 1406: fnd_message.set_name('ONT','ONT_OI_INL_SET_PARAMETER');

1402: Else
1403: IF l_debug_level > 0 THEN
1404: oe_debug_pub.add( 'ADD CUSTOMER PRIVILEGE IS NOT THERE' ) ;
1405: END IF;
1406: fnd_message.set_name('ONT','ONT_OI_INL_SET_PARAMETER');
1407: fnd_message.set_token('TYPE', 'Customers');
1408: oe_msg_pub.add;
1409: x_return_status := FND_API.G_RET_STS_ERROR;
1410: End If;

Line 1407: fnd_message.set_token('TYPE', 'Customers');

1403: IF l_debug_level > 0 THEN
1404: oe_debug_pub.add( 'ADD CUSTOMER PRIVILEGE IS NOT THERE' ) ;
1405: END IF;
1406: fnd_message.set_name('ONT','ONT_OI_INL_SET_PARAMETER');
1407: fnd_message.set_token('TYPE', 'Customers');
1408: oe_msg_pub.add;
1409: x_return_status := FND_API.G_RET_STS_ERROR;
1410: End If;
1411: -- End If to check whether Add Customer privilege is set}

Line 1419: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');

1415: IF l_debug_level > 0 THEN
1416: oe_debug_pub.add( 'PROBLEM IN CALL TO CREATE_ACCOUNT. ABORT PROCESSING' ) ;
1417: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
1418: END IF;
1419: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
1420: fnd_message.set_token('API_NAME', 'Create_Account');
1421: oe_msg_pub.add;
1422: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
1423: IF l_debug_level > 0 THEN

Line 1420: fnd_message.set_token('API_NAME', 'Create_Account');

1416: oe_debug_pub.add( 'PROBLEM IN CALL TO CREATE_ACCOUNT. ABORT PROCESSING' ) ;
1417: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
1418: END IF;
1419: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
1420: fnd_message.set_token('API_NAME', 'Create_Account');
1421: oe_msg_pub.add;
1422: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
1423: IF l_debug_level > 0 THEN
1424: oe_debug_pub.add( 'EXITING IN CREATE_ACCOUNT PROCEDURE WITH ERROR' ) ;

Line 1460: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');

1456: x_return_status := FND_API.G_RET_STS_ERROR;
1457: IF l_debug_level > 0 THEN
1458: oe_debug_pub.add( 'NO RECORD FOUND FOR THE PASSED EXISTING CUSTOMER , PLEASE CHECK DATA' ) ;
1459: END IF;
1460: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');
1461: fnd_message.set_token('REFERENCE', p_customer_number);
1462: oe_msg_pub.add;
1463: IF l_debug_level > 0 THEN
1464: oe_debug_pub.add( 'EXITING IN CREATE_ACCOUNT PROCEDURE WITH ERROR' ) ;

Line 1461: fnd_message.set_token('REFERENCE', p_customer_number);

1457: IF l_debug_level > 0 THEN
1458: oe_debug_pub.add( 'NO RECORD FOUND FOR THE PASSED EXISTING CUSTOMER , PLEASE CHECK DATA' ) ;
1459: END IF;
1460: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');
1461: fnd_message.set_token('REFERENCE', p_customer_number);
1462: oe_msg_pub.add;
1463: IF l_debug_level > 0 THEN
1464: oe_debug_pub.add( 'EXITING IN CREATE_ACCOUNT PROCEDURE WITH ERROR' ) ;
1465: END IF;

Line 1621: fnd_message.set_name('ONT','ONT_OI_INL_NO_USAGE_SET');

1617: nvl(address_info_rec.is_ship_to_address, 'N') <> 'Y' Then
1618: IF l_debug_level > 0 THEN
1619: oe_debug_pub.add( 'USAGE IS NOT SET FOR SHIP_TO. PLEASE CORRECT DATA' ) ;
1620: END IF;
1621: fnd_message.set_name('ONT','ONT_OI_INL_NO_USAGE_SET');
1622: fnd_message.set_token('USAGE', 'SHIP_TO');
1623: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1624: oe_msg_pub.add;
1625: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1622: fnd_message.set_token('USAGE', 'SHIP_TO');

1618: IF l_debug_level > 0 THEN
1619: oe_debug_pub.add( 'USAGE IS NOT SET FOR SHIP_TO. PLEASE CORRECT DATA' ) ;
1620: END IF;
1621: fnd_message.set_name('ONT','ONT_OI_INL_NO_USAGE_SET');
1622: fnd_message.set_token('USAGE', 'SHIP_TO');
1623: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1624: oe_msg_pub.add;
1625: x_return_status := FND_API.G_RET_STS_ERROR;
1626: Return;

Line 1623: fnd_message.set_token('REFERENCE', p_customer_info_ref);

1619: oe_debug_pub.add( 'USAGE IS NOT SET FOR SHIP_TO. PLEASE CORRECT DATA' ) ;
1620: END IF;
1621: fnd_message.set_name('ONT','ONT_OI_INL_NO_USAGE_SET');
1622: fnd_message.set_token('USAGE', 'SHIP_TO');
1623: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1624: oe_msg_pub.add;
1625: x_return_status := FND_API.G_RET_STS_ERROR;
1626: Return;
1627: Elsif p_type_of_address = 'BILL_TO' and

Line 1632: fnd_message.set_name('ONT','ONT_OI_INL_NO_USAGE_SET');

1628: nvl(address_info_rec.is_bill_to_address, 'N') <> 'Y' Then
1629: IF l_debug_level > 0 THEN
1630: oe_debug_pub.add( 'USAGE IS NOT SET FOR BILL_TO. PLEASE CORRECT DATA' ) ;
1631: END IF;
1632: fnd_message.set_name('ONT','ONT_OI_INL_NO_USAGE_SET');
1633: fnd_message.set_token('USAGE', 'BILL_TO');
1634: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1635: oe_msg_pub.add;
1636: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1633: fnd_message.set_token('USAGE', 'BILL_TO');

1629: IF l_debug_level > 0 THEN
1630: oe_debug_pub.add( 'USAGE IS NOT SET FOR BILL_TO. PLEASE CORRECT DATA' ) ;
1631: END IF;
1632: fnd_message.set_name('ONT','ONT_OI_INL_NO_USAGE_SET');
1633: fnd_message.set_token('USAGE', 'BILL_TO');
1634: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1635: oe_msg_pub.add;
1636: x_return_status := FND_API.G_RET_STS_ERROR;
1637: Return;

Line 1634: fnd_message.set_token('REFERENCE', p_customer_info_ref);

1630: oe_debug_pub.add( 'USAGE IS NOT SET FOR BILL_TO. PLEASE CORRECT DATA' ) ;
1631: END IF;
1632: fnd_message.set_name('ONT','ONT_OI_INL_NO_USAGE_SET');
1633: fnd_message.set_token('USAGE', 'BILL_TO');
1634: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1635: oe_msg_pub.add;
1636: x_return_status := FND_API.G_RET_STS_ERROR;
1637: Return;
1638: Elsif p_type_of_address = 'DELIVER_TO' and

Line 1643: fnd_message.set_name('ONT','ONT_OI_INL_NO_USAGE_SET');

1639: nvl(address_info_rec.is_deliver_to_address, 'N') <> 'Y' Then
1640: IF l_debug_level > 0 THEN
1641: oe_debug_pub.add( 'USAGE IS NOT SET FOR DELIVER_TO. PLEASE CORRECT DATA' ) ;
1642: END IF;
1643: fnd_message.set_name('ONT','ONT_OI_INL_NO_USAGE_SET');
1644: fnd_message.set_token('USAGE', 'DELIVER_TO');
1645: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1646: oe_msg_pub.add;
1647: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1644: fnd_message.set_token('USAGE', 'DELIVER_TO');

1640: IF l_debug_level > 0 THEN
1641: oe_debug_pub.add( 'USAGE IS NOT SET FOR DELIVER_TO. PLEASE CORRECT DATA' ) ;
1642: END IF;
1643: fnd_message.set_name('ONT','ONT_OI_INL_NO_USAGE_SET');
1644: fnd_message.set_token('USAGE', 'DELIVER_TO');
1645: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1646: oe_msg_pub.add;
1647: x_return_status := FND_API.G_RET_STS_ERROR;
1648: Return;

Line 1645: fnd_message.set_token('REFERENCE', p_customer_info_ref);

1641: oe_debug_pub.add( 'USAGE IS NOT SET FOR DELIVER_TO. PLEASE CORRECT DATA' ) ;
1642: END IF;
1643: fnd_message.set_name('ONT','ONT_OI_INL_NO_USAGE_SET');
1644: fnd_message.set_token('USAGE', 'DELIVER_TO');
1645: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1646: oe_msg_pub.add;
1647: x_return_status := FND_API.G_RET_STS_ERROR;
1648: Return;
1649: End If;

Line 1739: fnd_message.set_name('ONT','ONT_OI_INL_NO_PARENT_REF');

1735: Then
1736: IF l_debug_level > 0 THEN
1737: oe_debug_pub.add( 'PARENT_CUSTOMER_INFO_REF IS NULL' ) ;
1738: END IF;
1739: fnd_message.set_name('ONT','ONT_OI_INL_NO_PARENT_REF');
1740: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1741: oe_msg_pub.add;
1742: -- call msg routine
1743: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1740: fnd_message.set_token('REFERENCE', p_customer_info_ref);

1736: IF l_debug_level > 0 THEN
1737: oe_debug_pub.add( 'PARENT_CUSTOMER_INFO_REF IS NULL' ) ;
1738: END IF;
1739: fnd_message.set_name('ONT','ONT_OI_INL_NO_PARENT_REF');
1740: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1741: oe_msg_pub.add;
1742: -- call msg routine
1743: x_return_status := FND_API.G_RET_STS_ERROR;
1744: Return;

Line 1823: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');

1819: When No_Data_Found Then
1820: IF l_debug_level > 0 THEN
1821: oe_debug_pub.add( 'NO RECORD FOUND FOR THE PASSED EXISTING CUSTOMER , PLEASE CHECK DATA' ) ;
1822: END IF;
1823: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');
1824: fnd_message.set_token('REFERENCE', address_info_rec.Current_Customer_id);
1825: oe_msg_pub.add;
1826: x_return_status := FND_API.G_RET_STS_ERROR;
1827: Return;

Line 1824: fnd_message.set_token('REFERENCE', address_info_rec.Current_Customer_id);

1820: IF l_debug_level > 0 THEN
1821: oe_debug_pub.add( 'NO RECORD FOUND FOR THE PASSED EXISTING CUSTOMER , PLEASE CHECK DATA' ) ;
1822: END IF;
1823: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');
1824: fnd_message.set_token('REFERENCE', address_info_rec.Current_Customer_id);
1825: oe_msg_pub.add;
1826: x_return_status := FND_API.G_RET_STS_ERROR;
1827: Return;
1828: End;

Line 1879: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');

1875: -- Raise Error and Abort Processing
1876: IF l_debug_level > 0 THEN
1877: oe_debug_pub.add( 'TRYING TO ENTER THE SHIP TO WHICH ALREADY EXISTS' ) ;
1878: END IF;
1879: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
1880: fnd_message.set_token('TYPE', 'SHIP_TO ADDRESS');
1881: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1882: oe_msg_pub.add;
1883: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1880: fnd_message.set_token('TYPE', 'SHIP_TO ADDRESS');

1876: IF l_debug_level > 0 THEN
1877: oe_debug_pub.add( 'TRYING TO ENTER THE SHIP TO WHICH ALREADY EXISTS' ) ;
1878: END IF;
1879: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
1880: fnd_message.set_token('TYPE', 'SHIP_TO ADDRESS');
1881: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1882: oe_msg_pub.add;
1883: x_return_status := FND_API.G_RET_STS_ERROR;
1884: Update_Error_Flag(p_rowid => address_info_rec.rowid);

Line 1881: fnd_message.set_token('REFERENCE', p_customer_info_ref);

1877: oe_debug_pub.add( 'TRYING TO ENTER THE SHIP TO WHICH ALREADY EXISTS' ) ;
1878: END IF;
1879: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
1880: fnd_message.set_token('TYPE', 'SHIP_TO ADDRESS');
1881: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1882: oe_msg_pub.add;
1883: x_return_status := FND_API.G_RET_STS_ERROR;
1884: Update_Error_Flag(p_rowid => address_info_rec.rowid);
1885: Return;

Line 1912: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');

1908: -- Raise Error and Abort Processing
1909: IF l_debug_level > 0 THEN
1910: oe_debug_pub.add( 'TRYING TO ENTER THE BILL TO WHICH ALREADY EXISTS' ) ;
1911: END IF;
1912: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
1913: fnd_message.set_token('TYPE', 'BILL_TO ADDRESS');
1914: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1915: oe_msg_pub.add;
1916: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1913: fnd_message.set_token('TYPE', 'BILL_TO ADDRESS');

1909: IF l_debug_level > 0 THEN
1910: oe_debug_pub.add( 'TRYING TO ENTER THE BILL TO WHICH ALREADY EXISTS' ) ;
1911: END IF;
1912: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
1913: fnd_message.set_token('TYPE', 'BILL_TO ADDRESS');
1914: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1915: oe_msg_pub.add;
1916: x_return_status := FND_API.G_RET_STS_ERROR;
1917: Update_Error_Flag(p_rowid => address_info_rec.rowid);

Line 1914: fnd_message.set_token('REFERENCE', p_customer_info_ref);

1910: oe_debug_pub.add( 'TRYING TO ENTER THE BILL TO WHICH ALREADY EXISTS' ) ;
1911: END IF;
1912: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
1913: fnd_message.set_token('TYPE', 'BILL_TO ADDRESS');
1914: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1915: oe_msg_pub.add;
1916: x_return_status := FND_API.G_RET_STS_ERROR;
1917: Update_Error_Flag(p_rowid => address_info_rec.rowid);
1918: Return;

Line 1945: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');

1941: -- Raise Error and Abort Processing
1942: IF l_debug_level > 0 THEN
1943: oe_debug_pub.add( 'TRYING TO ENTER THE DELIVER TO WHICH ALREADY EXISTS' ) ;
1944: END IF;
1945: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
1946: fnd_message.set_token('TYPE', 'DELIVER_TO ADDRESS');
1947: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1948: oe_msg_pub.add;
1949: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1946: fnd_message.set_token('TYPE', 'DELIVER_TO ADDRESS');

1942: IF l_debug_level > 0 THEN
1943: oe_debug_pub.add( 'TRYING TO ENTER THE DELIVER TO WHICH ALREADY EXISTS' ) ;
1944: END IF;
1945: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
1946: fnd_message.set_token('TYPE', 'DELIVER_TO ADDRESS');
1947: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1948: oe_msg_pub.add;
1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950: Update_Error_Flag(p_rowid => address_info_rec.rowid);

Line 1947: fnd_message.set_token('REFERENCE', p_customer_info_ref);

1943: oe_debug_pub.add( 'TRYING TO ENTER THE DELIVER TO WHICH ALREADY EXISTS' ) ;
1944: END IF;
1945: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
1946: fnd_message.set_token('TYPE', 'DELIVER_TO ADDRESS');
1947: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1948: oe_msg_pub.add;
1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950: Update_Error_Flag(p_rowid => address_info_rec.rowid);
1951: Return;

Line 1973: fnd_message.set_name('ONT','ONT_OI_INL_REQD');

1969:
1970: IF nvl(G_AUTO_SITE_NUMBERING, 'Y') = 'N' AND
1971: address_info_rec.site_number IS NULL
1972: THEN
1973: fnd_message.set_name('ONT','ONT_OI_INL_REQD');
1974: fnd_message.set_token('API_NAME', 'Create_Address');
1975: fnd_message.set_token('FIELD_REQD', 'SITE_NUMBER');
1976: oe_msg_pub.add;
1977: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1974: fnd_message.set_token('API_NAME', 'Create_Address');

1970: IF nvl(G_AUTO_SITE_NUMBERING, 'Y') = 'N' AND
1971: address_info_rec.site_number IS NULL
1972: THEN
1973: fnd_message.set_name('ONT','ONT_OI_INL_REQD');
1974: fnd_message.set_token('API_NAME', 'Create_Address');
1975: fnd_message.set_token('FIELD_REQD', 'SITE_NUMBER');
1976: oe_msg_pub.add;
1977: x_return_status := FND_API.G_RET_STS_ERROR;
1978: IF l_debug_level > 0 THEN

Line 1975: fnd_message.set_token('FIELD_REQD', 'SITE_NUMBER');

1971: address_info_rec.site_number IS NULL
1972: THEN
1973: fnd_message.set_name('ONT','ONT_OI_INL_REQD');
1974: fnd_message.set_token('API_NAME', 'Create_Address');
1975: fnd_message.set_token('FIELD_REQD', 'SITE_NUMBER');
1976: oe_msg_pub.add;
1977: x_return_status := FND_API.G_RET_STS_ERROR;
1978: IF l_debug_level > 0 THEN
1979: oe_debug_pub.add( 'SPECIFY SITE NUMBER , PROFILE NO AUTO' ) ;

Line 1991: fnd_message.set_name('ONT','ONT_OI_INL_REQD');

1987:
1988: IF nvl(g_auto_location_numbering, 'Y') = 'N' AND
1989: address_info_rec.location_number IS NULL
1990: THEN
1991: fnd_message.set_name('ONT','ONT_OI_INL_REQD');
1992: fnd_message.set_token('API_NAME', 'Create_Address');
1993: fnd_message.set_token('FIELD_REQD', 'LOCATION_NUMBER');
1994: oe_msg_pub.add;
1995: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1992: fnd_message.set_token('API_NAME', 'Create_Address');

1988: IF nvl(g_auto_location_numbering, 'Y') = 'N' AND
1989: address_info_rec.location_number IS NULL
1990: THEN
1991: fnd_message.set_name('ONT','ONT_OI_INL_REQD');
1992: fnd_message.set_token('API_NAME', 'Create_Address');
1993: fnd_message.set_token('FIELD_REQD', 'LOCATION_NUMBER');
1994: oe_msg_pub.add;
1995: x_return_status := FND_API.G_RET_STS_ERROR;
1996: IF l_debug_level > 0 THEN

Line 1993: fnd_message.set_token('FIELD_REQD', 'LOCATION_NUMBER');

1989: address_info_rec.location_number IS NULL
1990: THEN
1991: fnd_message.set_name('ONT','ONT_OI_INL_REQD');
1992: fnd_message.set_token('API_NAME', 'Create_Address');
1993: fnd_message.set_token('FIELD_REQD', 'LOCATION_NUMBER');
1994: oe_msg_pub.add;
1995: x_return_status := FND_API.G_RET_STS_ERROR;
1996: IF l_debug_level > 0 THEN
1997: oe_debug_pub.add( 'SPECIFY LOCATION NUMBER' ) ;

Line 2436: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');

2432: END IF;
2433: IF l_debug_level > 0 THEN
2434: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
2435: END IF;
2436: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
2437: fnd_message.set_token('API_NAME', 'Create_Address');
2438: oe_msg_pub.add;
2439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2440: Update_Error_Flag(p_rowid => address_info_rec.rowid);

Line 2437: fnd_message.set_token('API_NAME', 'Create_Address');

2433: IF l_debug_level > 0 THEN
2434: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
2435: END IF;
2436: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
2437: fnd_message.set_token('API_NAME', 'Create_Address');
2438: oe_msg_pub.add;
2439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2440: Update_Error_Flag(p_rowid => address_info_rec.rowid);
2441: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);

Line 2454: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');

2450: If l_no_record_exists Then
2451: IF l_debug_level > 0 THEN
2452: oe_debug_pub.add( 'NO RECORD FOUND FOR THE PASSED REF , PLEASE CHECK DATA' ) ;
2453: END IF;
2454: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');
2455: fnd_message.set_token('REFERENCE', p_customer_info_ref);
2456: oe_msg_pub.add;
2457: x_return_status := FND_API.G_RET_STS_ERROR;
2458: IF l_debug_level > 0 THEN

Line 2455: fnd_message.set_token('REFERENCE', p_customer_info_ref);

2451: IF l_debug_level > 0 THEN
2452: oe_debug_pub.add( 'NO RECORD FOUND FOR THE PASSED REF , PLEASE CHECK DATA' ) ;
2453: END IF;
2454: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');
2455: fnd_message.set_token('REFERENCE', p_customer_info_ref);
2456: oe_msg_pub.add;
2457: x_return_status := FND_API.G_RET_STS_ERROR;
2458: IF l_debug_level > 0 THEN
2459: oe_debug_pub.add( 'EXITING IN CREATE_ADDRESS PROCEDURE WITH ERROR' ) ;

Line 2473: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');

2469: IF l_debug_level > 0 THEN
2470: oe_debug_pub.add( 'PROBLEM IN CALL TO CREATE_ADDRESS. ABORT PROCESSING' ) ;
2471: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
2472: END IF;
2473: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
2474: fnd_message.set_token('API_NAME', 'Create_Address');
2475: oe_msg_pub.add;
2476: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
2477: IF l_debug_level > 0 THEN

Line 2474: fnd_message.set_token('API_NAME', 'Create_Address');

2470: oe_debug_pub.add( 'PROBLEM IN CALL TO CREATE_ADDRESS. ABORT PROCESSING' ) ;
2471: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
2472: END IF;
2473: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
2474: fnd_message.set_token('API_NAME', 'Create_Address');
2475: oe_msg_pub.add;
2476: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
2477: IF l_debug_level > 0 THEN
2478: oe_debug_pub.add( 'EXITING IN CREATE_ADDRESS PROCEDURE WITH ERROR' ) ;

Line 2659: fnd_message.set_name('ONT','ONT_OI_INL_NO_PARENT_INFO');

2655: IF l_debug_level > 0 THEN
2656: oe_debug_pub.add( 'NO PARENT CUSTOMER REF POPULATED. CHECK THE DATA' ) ;
2657: END IF;
2658: x_return_status := FND_API.G_RET_STS_ERROR;
2659: fnd_message.set_name('ONT','ONT_OI_INL_NO_PARENT_INFO');
2660: fnd_message.set_token('REFERENCE', p_customer_info_ref);
2661: oe_msg_pub.add;
2662: return;
2663: End If;

Line 2660: fnd_message.set_token('REFERENCE', p_customer_info_ref);

2656: oe_debug_pub.add( 'NO PARENT CUSTOMER REF POPULATED. CHECK THE DATA' ) ;
2657: END IF;
2658: x_return_status := FND_API.G_RET_STS_ERROR;
2659: fnd_message.set_name('ONT','ONT_OI_INL_NO_PARENT_INFO');
2660: fnd_message.set_token('REFERENCE', p_customer_info_ref);
2661: oe_msg_pub.add;
2662: return;
2663: End If;
2664: -- End of if parent rec is passed or not}

Line 2714: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');

2710: When No_Data_Found Then
2711: IF l_debug_level > 0 THEN
2712: oe_debug_pub.add( 'NO RECORD FOUND FOR THE PASSED EXISTING CUSTOMER , PLEASE CHECK DATA' ) ;
2713: END IF;
2714: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');
2715: fnd_message.set_token('REFERENCE', contact_rec.Current_Customer_id);
2716: oe_msg_pub.add;
2717: x_return_status := FND_API.G_RET_STS_ERROR;
2718: Return;

Line 2715: fnd_message.set_token('REFERENCE', contact_rec.Current_Customer_id);

2711: IF l_debug_level > 0 THEN
2712: oe_debug_pub.add( 'NO RECORD FOUND FOR THE PASSED EXISTING CUSTOMER , PLEASE CHECK DATA' ) ;
2713: END IF;
2714: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');
2715: fnd_message.set_token('REFERENCE', contact_rec.Current_Customer_id);
2716: oe_msg_pub.add;
2717: x_return_status := FND_API.G_RET_STS_ERROR;
2718: Return;
2719: End;

Line 2751: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');

2747: -- Raise Error and Abort Processing
2748: IF l_debug_level > 0 THEN
2749: oe_debug_pub.add( 'TRYING TO ENTER THE SOLD_TO CONTACT WHICH ALREADY EXISTS' ) ;
2750: END IF;
2751: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
2752: fnd_message.set_token('REFERENCE', p_customer_info_ref);
2753: oe_msg_pub.add;
2754: x_return_status := FND_API.G_RET_STS_ERROR;
2755: Update_Error_Flag(p_rowid => contact_rec.rowid);

Line 2752: fnd_message.set_token('REFERENCE', p_customer_info_ref);

2748: IF l_debug_level > 0 THEN
2749: oe_debug_pub.add( 'TRYING TO ENTER THE SOLD_TO CONTACT WHICH ALREADY EXISTS' ) ;
2750: END IF;
2751: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
2752: fnd_message.set_token('REFERENCE', p_customer_info_ref);
2753: oe_msg_pub.add;
2754: x_return_status := FND_API.G_RET_STS_ERROR;
2755: Update_Error_Flag(p_rowid => contact_rec.rowid);
2756: Return;

Line 2772: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');

2768: -- Raise Error and Abort Processing
2769: IF l_debug_level > 0 THEN
2770: oe_debug_pub.add( 'TRYING TO ENTER THE SHIP_TO CONTACT WHICH ALREADY EXISTS' ) ;
2771: END IF;
2772: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
2773: fnd_message.set_token('REFERENCE', p_customer_info_ref);
2774: oe_msg_pub.add;
2775: x_return_status := FND_API.G_RET_STS_ERROR;
2776: Update_Error_Flag(p_rowid => contact_rec.rowid);

Line 2773: fnd_message.set_token('REFERENCE', p_customer_info_ref);

2769: IF l_debug_level > 0 THEN
2770: oe_debug_pub.add( 'TRYING TO ENTER THE SHIP_TO CONTACT WHICH ALREADY EXISTS' ) ;
2771: END IF;
2772: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
2773: fnd_message.set_token('REFERENCE', p_customer_info_ref);
2774: oe_msg_pub.add;
2775: x_return_status := FND_API.G_RET_STS_ERROR;
2776: Update_Error_Flag(p_rowid => contact_rec.rowid);
2777: Return;

Line 2793: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');

2789: -- Raise Error and Abort Processing
2790: IF l_debug_level > 0 THEN
2791: oe_debug_pub.add( 'TRYING TO ENTER THE BILL_TO CONTACT WHICH ALREADY EXISTS' ) ;
2792: END IF;
2793: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
2794: fnd_message.set_token('REFERENCE', p_customer_info_ref);
2795: oe_msg_pub.add;
2796: x_return_status := FND_API.G_RET_STS_ERROR;
2797: Update_Error_Flag(p_rowid => contact_rec.rowid);

Line 2794: fnd_message.set_token('REFERENCE', p_customer_info_ref);

2790: IF l_debug_level > 0 THEN
2791: oe_debug_pub.add( 'TRYING TO ENTER THE BILL_TO CONTACT WHICH ALREADY EXISTS' ) ;
2792: END IF;
2793: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
2794: fnd_message.set_token('REFERENCE', p_customer_info_ref);
2795: oe_msg_pub.add;
2796: x_return_status := FND_API.G_RET_STS_ERROR;
2797: Update_Error_Flag(p_rowid => contact_rec.rowid);
2798: Return;

Line 2814: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');

2810: -- Raise Error and Abort Processing
2811: IF l_debug_level > 0 THEN
2812: oe_debug_pub.add( 'TRYING TO ENTER THE DELIVER_TO CONTACT WHICH ALREADY EXISTS' ) ;
2813: END IF;
2814: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
2815: fnd_message.set_token('REFERENCE', p_customer_info_ref);
2816: oe_msg_pub.add;
2817: x_return_status := FND_API.G_RET_STS_ERROR;
2818: Update_Error_Flag(p_rowid => contact_rec.rowid);

Line 2815: fnd_message.set_token('REFERENCE', p_customer_info_ref);

2811: IF l_debug_level > 0 THEN
2812: oe_debug_pub.add( 'TRYING TO ENTER THE DELIVER_TO CONTACT WHICH ALREADY EXISTS' ) ;
2813: END IF;
2814: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
2815: fnd_message.set_token('REFERENCE', p_customer_info_ref);
2816: oe_msg_pub.add;
2817: x_return_status := FND_API.G_RET_STS_ERROR;
2818: Update_Error_Flag(p_rowid => contact_rec.rowid);
2819: Return;

Line 3186: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');

3182: END IF;
3183: IF l_debug_level > 0 THEN
3184: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3185: END IF;
3186: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
3187: fnd_message.set_token('API_NAME', 'Create_Contact');
3188: oe_msg_pub.add;
3189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3190: Update_Error_Flag(p_rowid => contact_rec.rowid);

Line 3187: fnd_message.set_token('API_NAME', 'Create_Contact');

3183: IF l_debug_level > 0 THEN
3184: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3185: END IF;
3186: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
3187: fnd_message.set_token('API_NAME', 'Create_Contact');
3188: oe_msg_pub.add;
3189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3190: Update_Error_Flag(p_rowid => contact_rec.rowid);
3191: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);

Line 3205: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');

3201: If l_no_record_exists Then
3202: IF l_debug_level > 0 THEN
3203: oe_debug_pub.add( 'NO RECORD FOUND FOR THE PASSED REF , PLEASE CHECK DATA' ) ;
3204: END IF;
3205: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');
3206: fnd_message.set_token('REFERENCE', p_customer_info_ref);
3207: oe_msg_pub.add;
3208: x_return_status := FND_API.G_RET_STS_ERROR;
3209: IF l_debug_level > 0 THEN

Line 3206: fnd_message.set_token('REFERENCE', p_customer_info_ref);

3202: IF l_debug_level > 0 THEN
3203: oe_debug_pub.add( 'NO RECORD FOUND FOR THE PASSED REF , PLEASE CHECK DATA' ) ;
3204: END IF;
3205: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');
3206: fnd_message.set_token('REFERENCE', p_customer_info_ref);
3207: oe_msg_pub.add;
3208: x_return_status := FND_API.G_RET_STS_ERROR;
3209: IF l_debug_level > 0 THEN
3210: oe_debug_pub.add( 'EXITING IN CREATE_CONTACT PROCEDURE WITH ERROR' ) ;

Line 3224: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');

3220: IF l_debug_level > 0 THEN
3221: oe_debug_pub.add( 'PROBLEM IN CALL TO CREATE_CONTACT. ABORT PROCESSING' ) ;
3222: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3223: END IF;
3224: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
3225: fnd_message.set_token('API_NAME', 'Create_Contact');
3226: oe_msg_pub.add;
3227: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
3228: IF l_debug_level > 0 THEN

Line 3225: fnd_message.set_token('API_NAME', 'Create_Contact');

3221: oe_debug_pub.add( 'PROBLEM IN CALL TO CREATE_CONTACT. ABORT PROCESSING' ) ;
3222: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3223: END IF;
3224: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
3225: fnd_message.set_token('API_NAME', 'Create_Contact');
3226: oe_msg_pub.add;
3227: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
3228: IF l_debug_level > 0 THEN
3229: oe_debug_pub.add( 'EXITING IN CREATE_CONTACT PROCEDURE WITH ERROR' ) ;

Line 3469: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');

3465: END IF;
3466: IF l_debug_level > 0 THEN
3467: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3468: END IF;
3469: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
3470: fnd_message.set_token('API_NAME', 'Create_Customer_Info');
3471: oe_msg_pub.add;
3472: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
3473: IF l_debug_level > 0 THEN

Line 3470: fnd_message.set_token('API_NAME', 'Create_Customer_Info');

3466: IF l_debug_level > 0 THEN
3467: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3468: END IF;
3469: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
3470: fnd_message.set_token('API_NAME', 'Create_Customer_Info');
3471: oe_msg_pub.add;
3472: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
3473: IF l_debug_level > 0 THEN
3474: oe_debug_pub.add( 'EXITING IN CREATE_CUSTOMER_INFO PROCEDURE WITH ERROR' ) ;

Line 3826: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');

3822: IF l_debug_level > 0 THEN
3823: oe_debug_pub.add( 'PROBLEM IN CALL TO DELETE_CUSTOMER_INFO. ABORT PROCESSING' ) ;
3824: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3825: END IF;
3826: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
3827: fnd_message.set_token('API_NAME', 'Delete_Customer_Info');
3828: oe_msg_pub.add;
3829: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
3830: IF l_debug_level > 0 THEN

Line 3827: fnd_message.set_token('API_NAME', 'Delete_Customer_Info');

3823: oe_debug_pub.add( 'PROBLEM IN CALL TO DELETE_CUSTOMER_INFO. ABORT PROCESSING' ) ;
3824: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3825: END IF;
3826: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
3827: fnd_message.set_token('API_NAME', 'Delete_Customer_Info');
3828: oe_msg_pub.add;
3829: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
3830: IF l_debug_level > 0 THEN
3831: oe_debug_pub.add( 'EXITING IN DELETE_CUSTOMER_INFO PROCEDURE WITH ERROR' ) ;