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 OE_MSG_PUB

Line 84: oe_msg_pub.add;

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' ) ;
88: END IF;

Line 85: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || 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' ) ;
88: END IF;
89: End Initialize_Global;

Line 142: oe_msg_pub.add;

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' ) ;
146: END IF;

Line 143: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || 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' ) ;
146: END IF;
147: End Validate_Party_Number;

Line 317: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => X_MSG_COUNT ) ) ;

313: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
314: END IF;
315: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
316: IF l_debug_level > 0 THEN
317: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => X_MSG_COUNT ) ) ;
318: END IF;
319: IF l_debug_level > 0 THEN
320: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM ACC RELATE '|| X_MSG_DATA ) ;
321: END IF;

Line 323: oe_msg_pub.transfer_msg_stack;

319: IF l_debug_level > 0 THEN
320: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM ACC RELATE '|| X_MSG_DATA ) ;
321: END IF;
322: x_return_status := l_return_status;
323: oe_msg_pub.transfer_msg_stack;
324: fnd_msg_pub.delete_msg;
325: IF l_debug_level > 0 THEN
326: oe_debug_pub.add( 'EXITING PROCEDURE CREATE_CUST_RELATIONSHIP' ) ;
327: END IF;

Line 347: oe_msg_pub.add;

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' ) ;
351: END IF;

Line 348: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || 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' ) ;
351: END IF;
352: END create_cust_relationship;

Line 486: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

482: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
483: END IF;
484: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
485: IF l_debug_level > 0 THEN
486: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
487: END IF;
488: IF l_debug_level > 0 THEN
489: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
490: END IF;

Line 492: oe_msg_pub.transfer_msg_stack;

488: IF l_debug_level > 0 THEN
489: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
490: END IF;
491: x_return_status := l_return_status;
492: oe_msg_pub.transfer_msg_stack;
493: fnd_msg_pub.delete_msg;
494: IF l_debug_level > 0 THEN
495: oe_debug_pub.add( 'EXITING CREATE ROLE RESPONSIBILITY API WITH ERROR' ) ;
496: END IF;

Line 537: oe_msg_pub.add;

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' ) ;
541: END IF;

Line 538: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || 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' ) ;
541: END IF;
542:

Line 612: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => X_MSG_COUNT ) ) ;

608: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
609: END IF;
610: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
611: IF l_debug_level > 0 THEN
612: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => X_MSG_COUNT ) ) ;
613: END IF;
614: IF l_debug_level > 0 THEN
615: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || X_MSG_DATA ) ;
616: END IF;

Line 618: oe_msg_pub.transfer_msg_stack;

614: IF l_debug_level > 0 THEN
615: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || X_MSG_DATA ) ;
616: END IF;
617: x_return_status := l_return_status;
618: oe_msg_pub.transfer_msg_stack;
619: fnd_msg_pub.delete_msg;
620: IF l_debug_level > 0 THEN
621: oe_debug_pub.add( 'EXITING CREATE CONTACT POINT API WITH ERROR' ) ;
622: END IF;

Line 654: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => X_MSG_COUNT ) ) ;

650: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
651: END IF;
652: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
653: IF l_debug_level > 0 THEN
654: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => X_MSG_COUNT ) ) ;
655: END IF;
656: IF l_debug_level > 0 THEN
657: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || X_MSG_DATA ) ;
658: END IF;

Line 660: oe_msg_pub.transfer_msg_stack;

656: IF l_debug_level > 0 THEN
657: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || X_MSG_DATA ) ;
658: END IF;
659: x_return_status := l_return_status;
660: oe_msg_pub.transfer_msg_stack;
661: fnd_msg_pub.delete_msg;
662: IF l_debug_level > 0 THEN
663: oe_debug_pub.add( 'EXITING CREATE CONTACT POINT API WITH ERROR' ) ;
664: END IF;

Line 684: oe_msg_pub.add;

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' ) ;
688: END IF;

Line 685: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || 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' ) ;
688: END IF;
689:

Line 808: OE_MSG_PUB.set_msg_context(

804: If OE_ORDER_IMPORT_SPECIFIC_PVT.G_ONT_ADD_CUSTOMER = 'Y' Then
805: IF l_debug_level > 0 THEN
806: oe_debug_pub.add( 'ADD CUSTOMER PRIVILEGE IS THERE' ) ;
807: END IF;
808: OE_MSG_PUB.set_msg_context(
809: p_entity_code => 'OI_INL_ADDCUST'
810: ,p_entity_ref => null
811: ,p_entity_id => null
812: ,p_header_id => null

Line 873: oe_msg_pub.add;

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;
877: Else

Line 881: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);

877: Else
878: -- As the data is not duplicate but the call to oe_value_to_id
879: -- has entered one error message in stack(necessary evil!)
880: -- What to do => here is solution delete it
881: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
882: End if; -- Duplicate account check
883: -- End Check for the Duplicate Information }
884:
885: -- { Start Check for the Required Information

Line 895: oe_msg_pub.add;

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
899:

Line 909: oe_msg_pub.add;

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
913:

Line 923: oe_msg_pub.add;

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
927: -- End Check for the Required Information }

Line 962: oe_msg_pub.add;

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' ) ;
966: END IF;

Line 1086: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

1082: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
1083: END IF;
1084: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
1085: IF l_debug_level > 0 THEN
1086: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
1087: END IF;
1088: IF l_debug_level > 0 THEN
1089: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
1090: END IF;

Line 1096: oe_msg_pub.transfer_msg_stack;

1092: IF l_debug_level > 0 THEN
1093: oe_debug_pub.add( 'EXITING IN CREATE_ACCOUNT PROCEDURE WITH ERROR' ) ;
1094: END IF;
1095: Update_Error_Flag(p_rowid => customer_rec.rowid);
1096: oe_msg_pub.transfer_msg_stack;
1097: fnd_msg_pub.delete_msg;
1098: return;
1099: Else
1100: IF l_debug_level > 0 THEN

Line 1240: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

1236: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
1237: END IF;
1238: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
1239: IF l_debug_level > 0 THEN
1240: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
1241: END IF;
1242: IF l_debug_level > 0 THEN
1243: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
1244: END IF;

Line 1250: oe_msg_pub.transfer_msg_stack;

1246: IF l_debug_level > 0 THEN
1247: oe_debug_pub.add( 'EXITING IN CREATE_ACCOUNT PROCEDURE WITH ERROR' ) ;
1248: END IF;
1249: Update_Error_Flag(p_rowid => customer_rec.rowid);
1250: oe_msg_pub.transfer_msg_stack;
1251: fnd_msg_pub.delete_msg;
1252: return;
1253: Else
1254: IF l_debug_level > 0 THEN

Line 1357: oe_msg_pub.add;

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;
1361: Update_Error_Flag(p_rowid => customer_rec.rowid);

Line 1378: oe_msg_pub.add;

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);
1382: IF l_debug_level > 0 THEN

Line 1381: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);

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);
1382: IF l_debug_level > 0 THEN
1383: oe_debug_pub.add( 'EXITING IN CREATE_ACCOUNT PROCEDURE WITH ERROR' ) ;
1384: END IF;
1385: End;

Line 1395: oe_msg_pub.add;

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' ) ;
1399: END IF;

Line 1408: oe_msg_pub.add;

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}
1412: Exception

Line 1421: oe_msg_pub.add;

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' ) ;
1425: END IF;

Line 1422: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || 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' ) ;
1425: END IF;
1426: End Create_Account;

Line 1462: oe_msg_pub.add;

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;
1466: End validate_customer_number;

Line 1591: OE_MSG_PUB.set_msg_context(

1587: END IF;
1588:
1589: x_return_status := FND_API.G_RET_STS_SUCCESS;
1590:
1591: OE_MSG_PUB.set_msg_context(
1592: p_entity_code => 'OI_INL_ADDCUST'
1593: ,p_entity_ref => null
1594: ,p_entity_id => null
1595: ,p_header_id => null

Line 1624: oe_msg_pub.add;

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
1628: nvl(address_info_rec.is_bill_to_address, 'N') <> 'Y' Then

Line 1635: oe_msg_pub.add;

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
1639: nvl(address_info_rec.is_deliver_to_address, 'N') <> 'Y' Then

Line 1646: oe_msg_pub.add;

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;
1650:

Line 1741: oe_msg_pub.add;

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;
1745: Else

Line 1795: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

1791: END IF;
1792:
1793: If l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1794: IF l_debug_level > 0 THEN
1795: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
1796: END IF;
1797: IF l_debug_level > 0 THEN
1798: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
1799: END IF;

Line 1825: oe_msg_pub.add;

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;
1829: Else

Line 1882: oe_msg_pub.add;

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;
1886: Else

Line 1890: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);

1886: Else
1887: -- As the data is not duplicate but the call to oe_value_to_id
1888: -- has entered one error message in stack(necessary evil!)
1889: -- What to do => here is solution delete it
1890: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
1891: End if; -- duplicate ship_to_org check
1892: Elsif p_type_of_address = 'BILL_TO' Then
1893: l_duplicate_address := Oe_Value_To_Id.Invoice_To_Org(
1894: p_invoice_to_address1 => address_info_rec.address1,

Line 1915: oe_msg_pub.add;

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;
1919: Else

Line 1923: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);

1919: Else
1920: -- As the data is not duplicate but the call to oe_value_to_id
1921: -- has entered one error message in stack(necessary evil!)
1922: -- What to do => here is solution delete it
1923: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
1924: End if; -- duplicate bill_to_org check
1925: Elsif p_type_of_address = 'DELIVER_TO' Then
1926: l_duplicate_address := Oe_Value_To_Id.Deliver_To_Org(
1927: p_deliver_to_address1 => address_info_rec.address1,

Line 1948: oe_msg_pub.add;

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;
1952: Else

Line 1956: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);

1952: Else
1953: -- As the data is not duplicate but the call to oe_value_to_id
1954: -- has entered one error message in stack(necessary evil!)
1955: -- What to do => here is solution delete it
1956: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
1957: End if; -- duplicate deliver_to_org check
1958: End If;
1959: -- End Of If For duplicate checking}
1960: END IF; ----end of skip duplicate check --bug 7299729

Line 1976: oe_msg_pub.add;

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' ) ;
1980: END IF;

Line 1994: oe_msg_pub.add;

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' ) ;
1998: END IF;

Line 2068: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

2064: IF l_debug_level > 0 THEN
2065: oe_debug_pub.add( 'HZ CREATE_LOCATION API ERROR ' ) ;
2066: END IF;
2067: IF l_debug_level > 0 THEN
2068: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
2069: END IF;
2070: IF l_debug_level > 0 THEN
2071: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
2072: END IF;

Line 2078: oe_msg_pub.transfer_msg_stack;

2074: IF l_debug_level > 0 THEN
2075: oe_debug_pub.add( 'EXITING IN CREATE_ADDRESS PROCEDURE WITH ERROR' ) ;
2076: END IF;
2077: Update_Error_Flag(p_rowid => address_info_rec.rowid);
2078: oe_msg_pub.transfer_msg_stack;
2079: fnd_msg_pub.delete_msg;
2080: return;
2081: End If;
2082:

Line 2143: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

2139: IF l_debug_level > 0 THEN
2140: oe_debug_pub.add( 'HZ CREATE_PARTY_SITE API ERROR ' ) ;
2141: END IF;
2142: IF l_debug_level > 0 THEN
2143: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
2144: END IF;
2145: IF l_debug_level > 0 THEN
2146: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
2147: END IF;

Line 2153: oe_msg_pub.transfer_msg_stack;

2149: IF l_debug_level > 0 THEN
2150: oe_debug_pub.add( 'EXITING IN CREATE_ADDRESS PROCEDURE WITH ERROR' ) ;
2151: END IF;
2152: Update_Error_Flag(p_rowid => address_info_rec.rowid);
2153: oe_msg_pub.transfer_msg_stack;
2154: fnd_msg_pub.delete_msg;
2155: return;
2156: End If;
2157:

Line 2234: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

2230: IF l_debug_level > 0 THEN
2231: oe_debug_pub.add( 'HZ CREATE_ACCOUNT_SITE API ERROR ' ) ;
2232: END IF;
2233: IF l_debug_level > 0 THEN
2234: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
2235: END IF;
2236: IF l_debug_level > 0 THEN
2237: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
2238: END IF;

Line 2244: oe_msg_pub.transfer_msg_stack;

2240: IF l_debug_level > 0 THEN
2241: oe_debug_pub.add( 'EXITING IN CREATE_ADDRESS PROCEDURE WITH ERROR' ) ;
2242: END IF;
2243: Update_Error_Flag(p_rowid => address_info_rec.rowid);
2244: oe_msg_pub.transfer_msg_stack;
2245: fnd_msg_pub.delete_msg;
2246: return;
2247: End If;
2248:

Line 2283: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

2279: IF l_debug_level > 0 THEN
2280: oe_debug_pub.add( 'HZ CREATE_SITE_USAGE API ERROR ' ) ;
2281: END IF;
2282: IF l_debug_level > 0 THEN
2283: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
2284: END IF;
2285: IF l_debug_level > 0 THEN
2286: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
2287: END IF;

Line 2293: oe_msg_pub.transfer_msg_stack;

2289: IF l_debug_level > 0 THEN
2290: oe_debug_pub.add( 'EXITING IN CREATE_ADDRESS PROCEDURE WITH ERROR' ) ;
2291: END IF;
2292: Update_Error_Flag(p_rowid => address_info_rec.rowid);
2293: oe_msg_pub.transfer_msg_stack;
2294: fnd_msg_pub.delete_msg;
2295: return;
2296: End If;
2297:

Line 2341: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

2337: IF l_debug_level > 0 THEN
2338: oe_debug_pub.add( 'HZ CREATE_SITE_USAGE API ERROR ' ) ;
2339: END IF;
2340: IF l_debug_level > 0 THEN
2341: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
2342: END IF;
2343: IF l_debug_level > 0 THEN
2344: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
2345: END IF;

Line 2351: oe_msg_pub.transfer_msg_stack;

2347: IF l_debug_level > 0 THEN
2348: oe_debug_pub.add( 'EXITING IN CREATE_ADDRESS PROCEDURE WITH ERROR' ) ;
2349: END IF;
2350: Update_Error_Flag(p_rowid => address_info_rec.rowid);
2351: oe_msg_pub.transfer_msg_stack;
2352: fnd_msg_pub.delete_msg;
2353: return;
2354: End If;
2355:

Line 2395: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

2391: IF l_debug_level > 0 THEN
2392: oe_debug_pub.add( 'HZ CREATE_SITE_USAGE API ERROR ' ) ;
2393: END IF;
2394: IF l_debug_level > 0 THEN
2395: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
2396: END IF;
2397: IF l_debug_level > 0 THEN
2398: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
2399: END IF;

Line 2408: oe_msg_pub.transfer_msg_stack;

2404: IF l_debug_level > 0 THEN
2405: oe_debug_pub.add( 'EXITING IN CREATE_ADDRESS PROCEDURE WITH ERROR' ) ;
2406: END IF;
2407: Update_Error_Flag(p_rowid => address_info_rec.rowid);
2408: oe_msg_pub.transfer_msg_stack;
2409: fnd_msg_pub.delete_msg;
2410: return;
2411: End If;
2412:

Line 2438: oe_msg_pub.add;

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);
2442: IF l_debug_level > 0 THEN

Line 2441: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);

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);
2442: IF l_debug_level > 0 THEN
2443: oe_debug_pub.add( 'EXITING IN CREATE_ADDRESS PROCEDURE WITH ERROR' ) ;
2444: END IF;
2445:

Line 2456: oe_msg_pub.add;

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' ) ;
2460: END IF;

Line 2475: oe_msg_pub.add;

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' ) ;
2479: END IF;

Line 2476: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || 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' ) ;
2479: END IF;
2480:

Line 2579: OE_MSG_PUB.set_msg_context(

2575: END IF;
2576:
2577: x_return_status := FND_API.G_RET_STS_SUCCESS;
2578:
2579: OE_MSG_PUB.set_msg_context(
2580: p_entity_code => 'OI_INL_ADDCUST'
2581: ,p_entity_ref => null
2582: ,p_entity_id => null
2583: ,p_header_id => null

Line 2661: oe_msg_pub.add;

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}
2665:

Line 2716: oe_msg_pub.add;

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;
2720: Else

Line 2753: oe_msg_pub.add;

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;
2757: Else

Line 2761: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);

2757: Else
2758: -- As the data is not duplicate but the call to oe_value_to_id
2759: -- has entered one error message in stack(necessary evil!)
2760: -- What to do => here is solution delete it
2761: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
2762: End if; -- duplicate sold_to contact check
2763: Elsif l_type_of_contact = 'SHIP_TO' Then
2764: l_sold_to_contact := Oe_Value_To_Id.Ship_To_Contact(
2765: p_ship_to_contact => l_contact_name,

Line 2774: oe_msg_pub.add;

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;
2778: Else

Line 2782: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);

2778: Else
2779: -- As the data is not duplicate but the call to oe_value_to_id
2780: -- has entered one error message in stack(necessary evil!)
2781: -- What to do => here is solution delete it
2782: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
2783: End if; -- duplicate ship_to contact check
2784: Elsif l_type_of_contact = 'BILL_TO' Then
2785: l_sold_to_contact := Oe_Value_To_Id.Invoice_To_Contact(
2786: p_invoice_to_contact => l_contact_name,

Line 2795: oe_msg_pub.add;

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;
2799: Else

Line 2803: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);

2799: Else
2800: -- As the data is not duplicate but the call to oe_value_to_id
2801: -- has entered one error message in stack(necessary evil!)
2802: -- What to do => here is solution delete it
2803: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
2804: End if; -- duplicate bill_to contact check
2805: Elsif l_type_of_contact = 'DELIVER_TO' Then
2806: l_sold_to_contact := Oe_Value_To_Id.Deliver_To_Contact(
2807: p_deliver_to_contact => l_contact_name,

Line 2816: oe_msg_pub.add;

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;
2820: Else

Line 2824: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);

2820: Else
2821: -- As the data is not duplicate but the call to oe_value_to_id
2822: -- has entered one error message in stack(necessary evil!)
2823: -- What to do => here is solution delete it
2824: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
2825: End if; -- duplicate deliver_to contact check
2826: End if;
2827: -- End of If for duplicate contact check}
2828:

Line 2901: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

2897: IF l_debug_level > 0 THEN
2898: oe_debug_pub.add( 'HZ CREATE_PERSON API ERROR ' ) ;
2899: END IF;
2900: IF l_debug_level > 0 THEN
2901: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
2902: END IF;
2903: IF l_debug_level > 0 THEN
2904: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
2905: END IF;

Line 2911: oe_msg_pub.transfer_msg_stack;

2907: IF l_debug_level > 0 THEN
2908: oe_debug_pub.add( 'EXITING IN CREATE_CONTACT PROCEDURE WITH ERROR' ) ;
2909: END IF;
2910: Update_Error_Flag(p_rowid => contact_rec.rowid);
2911: oe_msg_pub.transfer_msg_stack;
2912: fnd_msg_pub.delete_msg;
2913: return;
2914: End If;
2915:

Line 2992: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

2988: IF l_debug_level > 0 THEN
2989: oe_debug_pub.add( 'HZ CREATE_ORG_CONTACT API ERROR ' ) ;
2990: END IF;
2991: IF l_debug_level > 0 THEN
2992: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
2993: END IF;
2994: IF l_debug_level > 0 THEN
2995: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
2996: END IF;

Line 3002: oe_msg_pub.transfer_msg_stack;

2998: IF l_debug_level > 0 THEN
2999: oe_debug_pub.add( 'EXITING IN CREATE_CONTACT PROCEDURE WITH ERROR' ) ;
3000: END IF;
3001: Update_Error_Flag(p_rowid => contact_rec.rowid);
3002: oe_msg_pub.transfer_msg_stack;
3003: fnd_msg_pub.delete_msg;
3004: return;
3005: End If;
3006:

Line 3119: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

3115: IF l_debug_level > 0 THEN
3116: oe_debug_pub.add( 'HZ CREATE_CUST_ACCT_ROLES API ERROR ' ) ;
3117: END IF;
3118: IF l_debug_level > 0 THEN
3119: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
3120: END IF;
3121: IF l_debug_level > 0 THEN
3122: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
3123: END IF;

Line 3129: oe_msg_pub.transfer_msg_stack;

3125: IF l_debug_level > 0 THEN
3126: oe_debug_pub.add( 'EXITING IN CREATE_CONTACT PROCEDURE WITH ERROR' ) ;
3127: END IF;
3128: Update_Error_Flag(p_rowid => contact_rec.rowid);
3129: oe_msg_pub.transfer_msg_stack;
3130: fnd_msg_pub.delete_msg;
3131: return;
3132: End If;
3133: IF l_debug_level > 0 THEN

Line 3188: oe_msg_pub.add;

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);
3192: IF l_debug_level > 0 THEN

Line 3191: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);

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);
3192: IF l_debug_level > 0 THEN
3193: oe_debug_pub.add( 'EXITING IN CREATE_CONTACT PROCEDURE WITH ERROR' ) ;
3194: END IF;
3195: End;

Line 3207: oe_msg_pub.add;

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' ) ;
3211: END IF;

Line 3226: oe_msg_pub.add;

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' ) ;
3230: END IF;

Line 3227: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || 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' ) ;
3230: END IF;
3231: End Create_Contact;

Line 3471: oe_msg_pub.add;

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' ) ;
3475: END IF;

Line 3472: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || 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' ) ;
3475: END IF;
3476:

Line 3828: oe_msg_pub.add;

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' ) ;
3832: END IF;

Line 3829: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || 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' ) ;
3832: END IF;
3833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;