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.

[Home] [Help]

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 2435: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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