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.CSP_SHIP_TO_ADDRESS_PVT dependencies on FND_MSG_PUB

Line 775: fnd_msg_pub.count_and_get

771: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
772: 'x_msg_count=' || x_msg_count || ', x_msg_data=' || x_msg_data);
773: end if;
774:
775: fnd_msg_pub.count_and_get
776: ( p_count => x_msg_count
777: , p_data => x_msg_data);
778:
779: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 800: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

796: x_return_status := FND_API.G_RET_STS_ERROR;
797: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
798: P_API_NAME => L_API_NAME
799: ,P_PKG_NAME => G_PKG_NAME
800: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
801: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
802: ,X_MSG_COUNT => x_MSG_COUNT
803: ,X_MSG_DATA => x_MSG_DATA
804: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 816: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

812:
813: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
814: P_API_NAME => L_API_NAME
815: ,P_PKG_NAME => G_PKG_NAME
816: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
817: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
818: ,X_MSG_COUNT => x_MSG_COUNT
819: ,X_MSG_DATA => x_MSG_DATA
820: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 832: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

828:
829: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
830: P_API_NAME => L_API_NAME
831: ,P_PKG_NAME => G_PKG_NAME
832: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
833: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
834: ,X_MSG_COUNT => x_MSG_COUNT
835: ,X_MSG_DATA => x_MSG_DATA
836: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 852: FND_MSG_PUB.ADD;

848: Rollback to do_create_ship_to_location_PUB;
849: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
850: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
851: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
852: FND_MSG_PUB.ADD;
853: fnd_msg_pub.count_and_get
854: ( p_count => x_msg_count
855: , p_data => x_msg_data);
856: x_return_status := FND_API.G_RET_STS_ERROR;

Line 853: fnd_msg_pub.count_and_get

849: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
850: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
851: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
852: FND_MSG_PUB.ADD;
853: fnd_msg_pub.count_and_get
854: ( p_count => x_msg_count
855: , p_data => x_msg_data);
856: x_return_status := FND_API.G_RET_STS_ERROR;
857:

Line 992: FND_MSG_PUB.ADD;

988: IF l_inv_location_csr%NOTFOUND THEN
989: CLOSE l_inv_location_csr;
990: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INV_LOC_NOT_FOUND');
991: FND_MESSAGE.SET_TOKEN('TSK_ASSGN_ID', p_location_id, TRUE);
992: FND_MSG_PUB.ADD;
993: RAISE EXCP_USER_DEFINED;
994: END IF;
995: CLOSE l_inv_location_csr;
996:

Line 1068: fnd_msg_pub.count_and_get

1064: p_attribute_category => p_attribute_category
1065: );
1066:
1067: p_object_version_number := l_object_version_number;
1068: fnd_msg_pub.count_and_get
1069: ( p_count => x_msg_count
1070: , p_data => x_msg_data);
1071:
1072: -- Exception Block

Line 1080: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1076: x_return_status := FND_API.G_RET_STS_ERROR;
1077: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1078: P_API_NAME => L_API_NAME
1079: ,P_PKG_NAME => G_PKG_NAME
1080: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1081: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1082: ,X_MSG_COUNT => x_MSG_COUNT
1083: ,X_MSG_DATA => x_MSG_DATA
1084: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 1089: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1085: WHEN FND_API.G_EXC_ERROR THEN
1086: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1087: P_API_NAME => L_API_NAME
1088: ,P_PKG_NAME => G_PKG_NAME
1089: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1090: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1091: ,X_MSG_COUNT => x_MSG_COUNT
1092: ,X_MSG_DATA => x_MSG_DATA
1093: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 1098: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1095: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1096: P_API_NAME => L_API_NAME
1097: ,P_PKG_NAME => G_PKG_NAME
1098: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1099: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1100: ,X_MSG_COUNT => x_MSG_COUNT
1101: ,X_MSG_DATA => x_MSG_DATA
1102: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 1108: FND_MSG_PUB.ADD;

1104: Rollback to do_update_ship_to_location_PUB;
1105: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1106: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
1107: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
1108: FND_MSG_PUB.ADD;
1109: fnd_msg_pub.count_and_get
1110: ( p_count => x_msg_count
1111: , p_data => x_msg_data);
1112: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1109: fnd_msg_pub.count_and_get

1105: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1106: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
1107: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
1108: FND_MSG_PUB.ADD;
1109: fnd_msg_pub.count_and_get
1110: ( p_count => x_msg_count
1111: , p_data => x_msg_data);
1112: x_return_status := FND_API.G_RET_STS_ERROR;
1113:

Line 1318: FND_MSG_PUB.ADD;*/

1314: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1315: Rollback to do_create_site_use_PUB;
1316: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');
1317: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
1318: FND_MSG_PUB.ADD;*/
1319: RAISE EXCP_USER_DEFINED;
1320: END IF;
1321: END IF;
1322: s_location_id := null;

Line 1439: FND_MSG_PUB.ADD;*/

1435: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1436: Rollback to do_create_site_use_PUB;
1437: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');
1438: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
1439: FND_MSG_PUB.ADD;*/
1440: RAISE EXCP_USER_DEFINED;
1441: END IF;
1442:
1443: -- Exception Block

Line 1451: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1447: x_return_status := FND_API.G_RET_STS_ERROR;
1448: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1449: P_API_NAME => L_API_NAME
1450: ,P_PKG_NAME => G_PKG_NAME
1451: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1452: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1453: ,X_MSG_COUNT => x_MSG_COUNT
1454: ,X_MSG_DATA => x_MSG_DATA
1455: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 1460: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1456: WHEN FND_API.G_EXC_ERROR THEN
1457: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1458: P_API_NAME => L_API_NAME
1459: ,P_PKG_NAME => G_PKG_NAME
1460: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1461: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1462: ,X_MSG_COUNT => x_MSG_COUNT
1463: ,X_MSG_DATA => x_MSG_DATA
1464: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 1469: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1466: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1467: P_API_NAME => L_API_NAME
1468: ,P_PKG_NAME => G_PKG_NAME
1469: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1470: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1471: ,X_MSG_COUNT => x_MSG_COUNT
1472: ,X_MSG_DATA => x_MSG_DATA
1473: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 1479: FND_MSG_PUB.ADD;

1475: Rollback to do_create_site_use_PUB;
1476: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1477: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
1478: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
1479: FND_MSG_PUB.ADD;
1480: fnd_msg_pub.count_and_get
1481: ( p_count => x_msg_count
1482: , p_data => x_msg_data);
1483: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1480: fnd_msg_pub.count_and_get

1476: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1477: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
1478: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
1479: FND_MSG_PUB.ADD;
1480: fnd_msg_pub.count_and_get
1481: ( p_count => x_msg_count
1482: , p_data => x_msg_data);
1483: x_return_status := FND_API.G_RET_STS_ERROR;
1484:

Line 2108: FND_MSG_PUB.ADD;*/

2104: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2105: Rollback to do_update_site_use_PUB;
2106: /* FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');
2107: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
2108: FND_MSG_PUB.ADD;*/
2109: RAISE EXCP_USER_DEFINED;
2110: END IF;
2111: ELSE
2112: close l_cust_Bill_to_site_use_csr;

Line 2348: FND_MSG_PUB.ADD;*/

2344: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2345: Rollback to do_update_site_use_PUB;
2346: /* FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');
2347: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
2348: FND_MSG_PUB.ADD;*/
2349: RAISE EXCP_USER_DEFINED;
2350: END IF;
2351: ELSE
2352: close l_cust_site_use_csr;

Line 2585: FND_MSG_PUB.ADD;*/

2581: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2582: Rollback to do_update_site_use_PUB;
2583: /* FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');
2584: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
2585: FND_MSG_PUB.ADD;*/
2586: RAISE EXCP_USER_DEFINED;
2587: END IF;
2588: ELSE
2589: close l_cust_Bill_to_site_use_csr;

Line 2602: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2598: x_return_status := FND_API.G_RET_STS_ERROR;
2599: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2600: P_API_NAME => L_API_NAME
2601: ,P_PKG_NAME => G_PKG_NAME
2602: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2603: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2604: ,X_MSG_COUNT => x_MSG_COUNT
2605: ,X_MSG_DATA => x_MSG_DATA
2606: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 2611: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2607: WHEN FND_API.G_EXC_ERROR THEN
2608: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2609: P_API_NAME => L_API_NAME
2610: ,P_PKG_NAME => G_PKG_NAME
2611: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2612: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2613: ,X_MSG_COUNT => x_MSG_COUNT
2614: ,X_MSG_DATA => x_MSG_DATA
2615: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 2620: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2617: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2618: P_API_NAME => L_API_NAME
2619: ,P_PKG_NAME => G_PKG_NAME
2620: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2621: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2622: ,X_MSG_COUNT => x_MSG_COUNT
2623: ,X_MSG_DATA => x_MSG_DATA
2624: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 2630: FND_MSG_PUB.ADD;

2626: Rollback to do_update_site_use_PUB;
2627: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2628: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2629: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2630: FND_MSG_PUB.ADD;
2631: fnd_msg_pub.count_and_get
2632: ( p_count => x_msg_count
2633: , p_data => x_msg_data);
2634: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2631: fnd_msg_pub.count_and_get

2627: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2628: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2629: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2630: FND_MSG_PUB.ADD;
2631: fnd_msg_pub.count_and_get
2632: ( p_count => x_msg_count
2633: , p_data => x_msg_data);
2634: x_return_status := FND_API.G_RET_STS_ERROR;
2635:

Line 3148: FND_MSG_PUB.initialize;

3144: || ', p_object_version_number=' || p_object_version_number);
3145: end if;
3146:
3147: -- initialize message list
3148: FND_MSG_PUB.initialize;
3149:
3150: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3151: p_api_version_number,
3152: l_api_name,

Line 3165: FND_MSG_PUB.ADD;

3161:
3162: -- If task assignment id and addresses are both null, return error.
3163: IF (p_task_assignment_id IS NULL) and (p_country IS NULL) THEN
3164: FND_MESSAGE.SET_NAME ('CSP', 'CSP_TSK_ASSGN_ID_OR_ADDR_REQD');
3165: FND_MSG_PUB.ADD;
3166: RAISE EXCP_USER_DEFINED;
3167: END IF;
3168:
3169:

Line 3283: FND_MSG_PUB.ADD;*/

3279: IF x_return_status in ('E','U') THEN
3280: Rollback to ship_to_address_handler_PUB;
3281: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_STA_API_ERROR');
3282: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
3283: FND_MSG_PUB.ADD;*/
3284: RAISE EXCP_USER_DEFINED;
3285: END IF;
3286:
3287: END;

Line 3306: FND_MSG_PUB.ADD;

3302: IF l_resource_id_csr%NOTFOUND THEN
3303: CLOSE l_resource_id_csr;
3304: FND_MESSAGE.SET_NAME ('CSP', 'CSP_RESOURCE_ID_MISSING');
3305: FND_MESSAGE.SET_TOKEN('TSK_ASSGN_ID', p_task_assignment_id, false);
3306: FND_MSG_PUB.ADD;
3307: RAISE EXCP_USER_DEFINED;
3308: END IF;
3309: CLOSE l_resource_id_csr;
3310: END IF;

Line 3322: -- FND_MSG_PUB.ADD;

3318: IF l_requirement_hdr_csr%NOTFOUND THEN
3319: CLOSE l_requirement_hdr_csr;
3320: -- FND_MESSAGE.SET_NAME ('CSP', 'CSP_INV_LOC_MISSING');
3321: -- FND_MESSAGE.SET_TOKEN('TSK_ASSGN_ID', p_task_assignment_id, TRUE);
3322: -- FND_MSG_PUB.ADD;
3323: -- RAISE EXCP_USER_DEFINED;
3324: t_inv_location_id := null;
3325: l_timezone_id := null;
3326: ELSE

Line 3342: FND_MSG_PUB.ADD;

3338:
3339: IF l_inv_location_id IS NULL THEN
3340: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INV_LOC_MISSING');
3341: FND_MESSAGE.SET_TOKEN('TSK_ASSGN_ID', p_task_assignment_id, false);
3342: FND_MSG_PUB.ADD;
3343: RAISE EXCP_USER_DEFINED;
3344: END IF;
3345:
3346: -- Get party_id if it exists for this resource

Line 3377: FND_MSG_PUB.ADD;

3373: CLOSE l_party_id_csr;
3374: FND_MESSAGE.SET_NAME ('CSP', 'CSP_PARTY_ID_MISSING');
3375: FND_MESSAGE.SET_TOKEN('RESOURCE_ID', l_resource_id, false);
3376: FND_MESSAGE.SET_TOKEN('CUST_ID', l_customer_id, false);
3377: FND_MSG_PUB.ADD;
3378: RAISE EXCP_USER_DEFINED;
3379: END IF;
3380: CLOSE l_party_id_csr;
3381:

Line 3400: -- FND_MSG_PUB.ADD;

3396: -- FND_MESSAGE.SET_NAME ('CSP', 'CSP_RESOURCE_NAME_MISSING');
3397: -- FND_MESSAGE.SET_TOKEN('TSK_ASSGN_ID', p_task_assignment_id, TRUE);
3398: -- FND_MESSAGE.SET_TOKEN('RESOURCE_CODE', l_resource_type, TRUE);
3399: -- FND_MESSAGE.SET_TOKEN('RESOURCE_ID', l_resource_id, TRUE);
3400: -- FND_MSG_PUB.ADD;
3401: -- RAISE EXCP_USER_DEFINED;
3402: l_resource_name := csp_pick_utils.get_object_name(l_resource_type, l_resource_id);
3403: l_first_name := l_resource_name;
3404: l_last_name := l_resource_name;

Line 3508: FND_MSG_PUB.ADD;*/

3504: IF x_return_status in ('E','U') THEN
3505: Rollback to ship_to_address_handler_PUB;
3506: /* FND_MESSAGE.SET_NAME ('CSP', 'CSP_PROF_API_ERROR');
3507: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
3508: FND_MSG_PUB.ADD;*/
3509: RAISE EXCP_USER_DEFINED;
3510: END IF;
3511:
3512: -- if auto generate customer number is no, pass the customer number to the API

Line 3763: FND_MSG_PUB.ADD;*/

3759: IF x_return_status in ('E','U') THEN
3760: Rollback to ship_to_address_handler_PUB;
3761: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_CUST_API_ERROR');
3762: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
3763: FND_MSG_PUB.ADD;*/
3764: RAISE EXCP_USER_DEFINED;
3765: ELSE
3766: -- Create/update resource customer relationship in csp_rs_cust_relations.
3767: do_rs_cust_relations(l_resource_type, l_resource_id, l_customer_id);

Line 3783: FND_MSG_PUB.ADD;

3779: IF l_inv_loc_csr%NOTFOUND THEN
3780: CLOSE l_inv_loc_csr;
3781: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INV_LOC_NOT_FOUND');
3782: FND_MESSAGE.SET_TOKEN ('LOC_ID', 'l_inv_location_id',false);
3783: FND_MSG_PUB.ADD;
3784: RAISE EXCP_USER_DEFINED;
3785: END IF;
3786: CLOSE l_inv_loc_csr;
3787: s_province := p_province;

Line 3837: FND_MSG_PUB.ADD;

3833: IF t_customer_id <> l_customer_id THEN
3834: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INV_LOC_HAS_ASSIGNED');
3835: FND_MESSAGE.SET_TOKEN ('LOC_ID', 'l_inv_location_id',false);
3836: FND_MESSAGE.SET_TOKEN ('CUSTOMER_ID', 't_customer_id',false);
3837: FND_MSG_PUB.ADD;
3838: RAISE EXCP_USER_DEFINED;
3839: ELSE
3840: IF p_status IS NOT NULL THEN
3841: t_status := p_status;

Line 3882: FND_MSG_PUB.ADD;*/

3878: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3879: Rollback to ship_to_address_handler_PUB;
3880: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');
3881: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
3882: FND_MSG_PUB.ADD;*/
3883: RAISE EXCP_USER_DEFINED;
3884: END IF;
3885:
3886:

Line 3987: FND_MSG_PUB.ADD;*/

3983: IF x_return_status in ('E','U') THEN
3984: Rollback to ship_to_address_handler_PUB;
3985: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_ADDR_API_ERROR');
3986: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
3987: FND_MSG_PUB.ADD;*/
3988: RAISE EXCP_USER_DEFINED;
3989: END IF;
3990: ELSE
3991: arh_addr_pkg.update_row (

Line 4087: FND_MSG_PUB.ADD;*/

4083: IF x_return_status in ('E','U') THEN
4084: Rollback to ship_to_address_handler_PUB;
4085: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_ADDR_API_ERROR');
4086: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
4087: FND_MSG_PUB.ADD;*/
4088: RAISE EXCP_USER_DEFINED;
4089: END IF;
4090: IF p_primary_flag IS NOT NULL or p_status IS NOT NULL THEN
4091: do_update_site_use

Line 4106: FND_MSG_PUB.ADD;*/

4102: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4103: Rollback to ship_to_address_handler_PUB;
4104: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');
4105: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
4106: FND_MSG_PUB.ADD;*/
4107: RAISE EXCP_USER_DEFINED;
4108: END IF;
4109:
4110: END IF;

Line 4253: FND_MSG_PUB.ADD;*/

4249: IF x_return_status in ('E','U') THEN
4250: Rollback to ship_to_address_handler_PUB;
4251: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_ADDR_API_ERROR');
4252: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
4253: FND_MSG_PUB.ADD;*/
4254: RAISE EXCP_USER_DEFINED;
4255: END IF;
4256:
4257: IF l_timezone_id IS NOT NULL THEN

Line 4279: FND_MSG_PUB.ADD;*/

4275: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4276: Rollback to ship_to_address_handler_PUB;
4277: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');
4278: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
4279: FND_MSG_PUB.ADD;*/
4280: RAISE EXCP_USER_DEFINED;
4281: END IF;
4282: END IF;
4283: END;

Line 4303: fnd_msg_pub.count_and_get

4299: IF p_commit = FND_API.G_TRUE THEN
4300: COMMIT;
4301: END IF;
4302:
4303: fnd_msg_pub.count_and_get
4304: ( p_count => x_msg_count
4305: , p_data => x_msg_data);
4306:
4307: -- Exception Block --

Line 4315: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4311: x_return_status := FND_API.G_RET_STS_ERROR;
4312: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4313: P_API_NAME => L_API_NAME
4314: ,P_PKG_NAME => G_PKG_NAME
4315: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4316: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4317: ,X_MSG_COUNT => X_MSG_COUNT
4318: ,X_MSG_DATA => X_MSG_DATA
4319: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4324: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4320: WHEN FND_API.G_EXC_ERROR THEN
4321: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4322: P_API_NAME => L_API_NAME
4323: ,P_PKG_NAME => G_PKG_NAME
4324: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4325: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4326: ,X_MSG_COUNT => X_MSG_COUNT
4327: ,X_MSG_DATA => X_MSG_DATA
4328: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4333: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4330: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4331: P_API_NAME => L_API_NAME
4332: ,P_PKG_NAME => G_PKG_NAME
4333: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4334: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4335: ,X_MSG_COUNT => X_MSG_COUNT
4336: ,X_MSG_DATA => X_MSG_DATA
4337: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4343: FND_MSG_PUB.ADD;

4339: Rollback to ship_to_address_handler_PUB;
4340: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4341: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
4342: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
4343: FND_MSG_PUB.ADD;
4344: fnd_msg_pub.count_and_get
4345: ( p_count => x_msg_count
4346: , p_data => x_msg_data);
4347: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4344: fnd_msg_pub.count_and_get

4340: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4341: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
4342: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
4343: FND_MSG_PUB.ADD;
4344: fnd_msg_pub.count_and_get
4345: ( p_count => x_msg_count
4346: , p_data => x_msg_data);
4347: x_return_status := FND_API.G_RET_STS_ERROR;
4348:

Line 4425: FND_MSG_PUB.initialize;

4421: BEGIN
4422: SAVEPOINT site_to_invloc_linkage_PUB;
4423:
4424: -- initialize message list
4425: FND_MSG_PUB.initialize;
4426:
4427: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4428: p_api_version_number,
4429: l_api_name,

Line 4439: FND_MSG_PUB.ADD;

4435:
4436: -- If site use id is null, return error.
4437: IF p_site_use_id IS NULL THEN
4438: FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_ID_REQD');
4439: FND_MSG_PUB.ADD;
4440: RAISE EXCP_USER_DEFINED;
4441: END IF;
4442:
4443: -- If address fields are not null, create a new inventory location. Otherwise, return error.

Line 4500: FND_MSG_PUB.ADD;*/

4496: IF x_return_status in ('E','U') THEN
4497: Rollback to site_to_invloc_linkage_PUB;
4498: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_STA_API_ERROR');
4499: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
4500: FND_MSG_PUB.ADD;*/
4501: /* RAISE EXCP_USER_DEFINED;
4502: ELSE
4503:
4504: -- Create the linkage between the site use and the inventory location.

Line 4517: FND_MSG_PUB.ADD;

4513: ELSE
4514: Rollback to site_to_invloc_linkage_PUB;
4515: FND_MESSAGE.SET_NAME ('CSP', 'CSP_ADDRESS_REQD');
4516: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data,false);
4517: FND_MSG_PUB.ADD;
4518: RAISE EXCP_USER_DEFINED;
4519: END IF;
4520:
4521: EXCEPTION

Line 4524: fnd_msg_pub.count_and_get

4520:
4521: EXCEPTION
4522: WHEN EXCP_USER_DEFINED THEN
4523: x_return_status := FND_API.G_RET_STS_ERROR;
4524: fnd_msg_pub.count_and_get
4525: ( p_count => x_msg_count
4526: , p_data => x_msg_data);
4527: WHEN FND_API.G_EXC_ERROR THEN
4528: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 4531: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4527: WHEN FND_API.G_EXC_ERROR THEN
4528: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4529: P_API_NAME => L_API_NAME
4530: ,P_PKG_NAME => G_PKG_NAME
4531: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4532: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4533: ,X_MSG_COUNT => x_MSG_COUNT
4534: ,X_MSG_DATA => x_MSG_DATA
4535: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 4540: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4537: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4538: P_API_NAME => L_API_NAME
4539: ,P_PKG_NAME => G_PKG_NAME
4540: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4541: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4542: ,X_MSG_COUNT => x_MSG_COUNT
4543: ,X_MSG_DATA => x_MSG_DATA
4544: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 4550: FND_MSG_PUB.ADD;

4546: Rollback to site_to_invloc_linkage_PUB;
4547: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4548: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
4549: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
4550: FND_MSG_PUB.ADD;
4551: fnd_msg_pub.count_and_get
4552: ( p_count => x_msg_count
4553: , p_data => x_msg_data);
4554: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4551: fnd_msg_pub.count_and_get

4547: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4548: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
4549: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
4550: FND_MSG_PUB.ADD;
4551: fnd_msg_pub.count_and_get
4552: ( p_count => x_msg_count
4553: , p_data => x_msg_data);
4554: x_return_status := FND_API.G_RET_STS_ERROR;
4555:

Line 4654: FND_MSG_PUB.initialize;

4650:
4651: SAVEPOINT site_to_invloc_linkage_PUB;
4652:
4653: -- initialize message list
4654: FND_MSG_PUB.initialize;
4655:
4656: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4657: p_api_version_number,
4658: l_api_name,

Line 4675: FND_MSG_PUB.ADD;

4671:
4672: -- If site use id is null, return error.
4673: IF p_site_use_id IS NULL THEN
4674: FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_ID_REQD');
4675: FND_MSG_PUB.ADD;
4676: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4677: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4678: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4679: 'In CSP_SITE_USE_ID_REQD error');

Line 4773: FND_MSG_PUB.ADD;*/

4769: IF x_return_status in ('E','U') THEN
4770: Rollback to site_to_invloc_linkage_PUB;
4771: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_STA_API_ERROR');
4772: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
4773: FND_MSG_PUB.ADD;*/
4774: RAISE EXCP_USER_DEFINED;
4775: ELSE
4776:
4777: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 4873: FND_MSG_PUB.ADD;

4869: 'p_country is NULL');
4870: end if;
4871: FND_MESSAGE.SET_NAME ('CSP', 'CSP_ADDRESS_REQD');
4872: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
4873: FND_MSG_PUB.ADD;
4874: RAISE EXCP_USER_DEFINED;
4875: END IF;
4876: ELSE
4877: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 4973: FND_MSG_PUB.ADD;*/

4969: IF x_return_status in ('E','U') THEN
4970: Rollback to site_to_invloc_linkage_PUB;
4971: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_STA_API_ERROR');
4972: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
4973: FND_MSG_PUB.ADD;*/
4974: RAISE EXCP_USER_DEFINED;
4975: ELSE
4976:
4977: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 5063: FND_MSG_PUB.ADD;*/

5059: 'p_country is NULL...');
5060: end if;
5061: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_ADDRESS_REQD');
5062: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
5063: FND_MSG_PUB.ADD;*/
5064: RAISE EXCP_USER_DEFINED;
5065: END IF;
5066: END IF;
5067: EXCEPTION

Line 5070: fnd_msg_pub.count_and_get

5066: END IF;
5067: EXCEPTION
5068: WHEN EXCP_USER_DEFINED THEN
5069: x_return_status := FND_API.G_RET_STS_ERROR;
5070: fnd_msg_pub.count_and_get
5071: ( p_count => x_msg_count
5072: , p_data => x_msg_data);
5073: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5074: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 5082: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

5078: WHEN FND_API.G_EXC_ERROR THEN
5079: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
5080: P_API_NAME => L_API_NAME
5081: ,P_PKG_NAME => G_PKG_NAME
5082: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5083: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
5084: ,X_MSG_COUNT => x_MSG_COUNT
5085: ,X_MSG_DATA => x_MSG_DATA
5086: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 5096: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

5092: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5093: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
5094: P_API_NAME => L_API_NAME
5095: ,P_PKG_NAME => G_PKG_NAME
5096: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5097: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
5098: ,X_MSG_COUNT => x_MSG_COUNT
5099: ,X_MSG_DATA => x_MSG_DATA
5100: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 5116: FND_MSG_PUB.ADD;

5112: end if;
5113: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
5114: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
5115: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
5116: FND_MSG_PUB.ADD;
5117: fnd_msg_pub.count_and_get
5118: ( p_count => x_msg_count
5119: , p_data => x_msg_data);
5120: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5117: fnd_msg_pub.count_and_get

5113: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
5114: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
5115: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
5116: FND_MSG_PUB.ADD;
5117: fnd_msg_pub.count_and_get
5118: ( p_count => x_msg_count
5119: , p_data => x_msg_data);
5120: x_return_status := FND_API.G_RET_STS_ERROR;
5121:

Line 5191: fnd_msg_pub.add;

5187: fnd_message.set_token (
5188: 'P_PROCEDURE',
5189: i.hook_package || '.' || i.hook_api,false
5190: );
5191: fnd_msg_pub.add;
5192: x_return_status := fnd_api.g_ret_sts_unexp_error;
5193: RAISE fnd_api.g_exc_unexpected_error;
5194: x_return_status := fnd_api.g_ret_sts_unexp_error;
5195: RAISE fnd_api.g_exc_unexpected_error;

Line 5201: fnd_msg_pub.add;

5197:
5198: IF x_return_status IS NULL
5199: THEN
5200: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');
5201: fnd_msg_pub.add;
5202: x_return_status := fnd_api.g_ret_sts_unexp_error;
5203: RAISE fnd_api.g_exc_unexpected_error;
5204: END IF;
5205: END LOOP;

Line 5214: fnd_msg_pub.add;

5210: WHEN OTHERS
5211: THEN
5212: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
5213: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM,false);
5214: fnd_msg_pub.add;
5215: x_return_status := fnd_api.g_ret_sts_unexp_error;
5216: END;
5217:
5218: PROCEDURE cust_inv_loc_link

Line 5476: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

5472: WHEN FND_API.G_EXC_ERROR THEN
5473: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
5474: P_API_NAME => L_API_NAME
5475: ,P_PKG_NAME => G_PKG_NAME
5476: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5477: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
5478: ,X_MSG_COUNT => X_MSG_COUNT
5479: ,X_MSG_DATA => X_MSG_DATA
5480: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 5485: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

5481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5482: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
5483: P_API_NAME => L_API_NAME
5484: ,P_PKG_NAME => G_PKG_NAME
5485: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5486: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
5487: ,X_MSG_COUNT => X_MSG_COUNT
5488: ,X_MSG_DATA => X_MSG_DATA
5489: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 5495: FND_MSG_PUB.ADD;

5491: Rollback to cust_inv_loc_link_pub;
5492: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
5493: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
5494: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
5495: FND_MSG_PUB.ADD;
5496: fnd_msg_pub.count_and_get
5497: ( p_count => x_msg_count
5498: , p_data => x_msg_data);
5499: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5496: fnd_msg_pub.count_and_get

5492: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
5493: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
5494: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
5495: FND_MSG_PUB.ADD;
5496: fnd_msg_pub.count_and_get
5497: ( p_count => x_msg_count
5498: , p_data => x_msg_data);
5499: x_return_status := FND_API.G_RET_STS_ERROR;
5500:

Line 5571: FND_MSG_PUB.initialize;

5567: x_return_status := FND_API.G_RET_STS_SUCCESS;
5568:
5569: IF FND_API.to_Boolean(p_Init_Msg_List)
5570: THEN
5571: FND_MSG_PUB.initialize;
5572: END IF;
5573:
5574:
5575: /*

Line 5747: FND_MSG_PUB.initialize;

5743: x_return_status := FND_API.G_RET_STS_SUCCESS;
5744:
5745: IF FND_API.to_Boolean(p_Init_Msg_List)
5746: THEN
5747: FND_MSG_PUB.initialize;
5748: END IF;
5749:
5750: /*
5751: Logic in brief

Line 5893: FND_MSG_PUB.ADD;

5889: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5890: l_msg := x_msg_data;
5891: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');
5892: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);
5893: FND_MSG_PUB.ADD;
5894: fnd_msg_pub.count_and_get
5895: ( p_count => x_msg_count
5896: , p_data => x_msg_data);
5897: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5894: fnd_msg_pub.count_and_get

5890: l_msg := x_msg_data;
5891: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');
5892: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);
5893: FND_MSG_PUB.ADD;
5894: fnd_msg_pub.count_and_get
5895: ( p_count => x_msg_count
5896: , p_data => x_msg_data);
5897: x_return_status := FND_API.G_RET_STS_ERROR;
5898: RAISE FND_API.G_EXC_ERROR;

Line 5928: FND_MSG_PUB.ADD;

5924: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5925: l_msg := x_msg_data;
5926: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');
5927: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);
5928: FND_MSG_PUB.ADD;
5929: fnd_msg_pub.count_and_get
5930: ( p_count => x_msg_count
5931: , p_data => x_msg_data);
5932: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5929: fnd_msg_pub.count_and_get

5925: l_msg := x_msg_data;
5926: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');
5927: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);
5928: FND_MSG_PUB.ADD;
5929: fnd_msg_pub.count_and_get
5930: ( p_count => x_msg_count
5931: , p_data => x_msg_data);
5932: x_return_status := FND_API.G_RET_STS_ERROR;
5933: RAISE FND_API.G_EXC_ERROR;

Line 5963: FND_MSG_PUB.ADD;

5959: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5960: l_msg := x_msg_data;
5961: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');
5962: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);
5963: FND_MSG_PUB.ADD;
5964: fnd_msg_pub.count_and_get
5965: ( p_count => x_msg_count
5966: , p_data => x_msg_data);
5967: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5964: fnd_msg_pub.count_and_get

5960: l_msg := x_msg_data;
5961: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');
5962: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);
5963: FND_MSG_PUB.ADD;
5964: fnd_msg_pub.count_and_get
5965: ( p_count => x_msg_count
5966: , p_data => x_msg_data);
5967: x_return_status := FND_API.G_RET_STS_ERROR;
5968: RAISE FND_API.G_EXC_ERROR;

Line 6020: FND_MSG_PUB.ADD;

6016: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6017: l_msg := x_msg_data;
6018: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');
6019: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);
6020: FND_MSG_PUB.ADD;
6021: fnd_msg_pub.count_and_get
6022: ( p_count => x_msg_count
6023: , p_data => x_msg_data);
6024: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6021: fnd_msg_pub.count_and_get

6017: l_msg := x_msg_data;
6018: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');
6019: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);
6020: FND_MSG_PUB.ADD;
6021: fnd_msg_pub.count_and_get
6022: ( p_count => x_msg_count
6023: , p_data => x_msg_data);
6024: x_return_status := FND_API.G_RET_STS_ERROR;
6025: RAISE FND_API.G_EXC_ERROR;

Line 6055: FND_MSG_PUB.ADD;

6051: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6052: l_msg := x_msg_data;
6053: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');
6054: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);
6055: FND_MSG_PUB.ADD;
6056: fnd_msg_pub.count_and_get
6057: ( p_count => x_msg_count
6058: , p_data => x_msg_data);
6059: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6056: fnd_msg_pub.count_and_get

6052: l_msg := x_msg_data;
6053: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');
6054: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);
6055: FND_MSG_PUB.ADD;
6056: fnd_msg_pub.count_and_get
6057: ( p_count => x_msg_count
6058: , p_data => x_msg_data);
6059: x_return_status := FND_API.G_RET_STS_ERROR;
6060: RAISE FND_API.G_EXC_ERROR;

Line 6086: FND_MSG_PUB.ADD;

6082: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6083: l_msg := x_msg_data;
6084: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');
6085: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);
6086: FND_MSG_PUB.ADD;
6087: fnd_msg_pub.count_and_get
6088: ( p_count => x_msg_count
6089: , p_data => x_msg_data);
6090: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6087: fnd_msg_pub.count_and_get

6083: l_msg := x_msg_data;
6084: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');
6085: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);
6086: FND_MSG_PUB.ADD;
6087: fnd_msg_pub.count_and_get
6088: ( p_count => x_msg_count
6089: , p_data => x_msg_data);
6090: x_return_status := FND_API.G_RET_STS_ERROR;
6091: RAISE FND_API.G_EXC_ERROR;

Line 6123: FND_MSG_PUB.ADD;

6119: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6120: l_msg := x_msg_data;
6121: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');
6122: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);
6123: FND_MSG_PUB.ADD;
6124: fnd_msg_pub.count_and_get
6125: ( p_count => x_msg_count
6126: , p_data => x_msg_data);
6127: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6124: fnd_msg_pub.count_and_get

6120: l_msg := x_msg_data;
6121: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');
6122: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);
6123: FND_MSG_PUB.ADD;
6124: fnd_msg_pub.count_and_get
6125: ( p_count => x_msg_count
6126: , p_data => x_msg_data);
6127: x_return_status := FND_API.G_RET_STS_ERROR;
6128: po_moac_utils_pvt.set_org_context(l_current_org_id);

Line 6173: FND_MSG_PUB.ADD;

6169: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6170: l_msg := x_msg_data;
6171: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');
6172: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);
6173: FND_MSG_PUB.ADD;
6174: fnd_msg_pub.count_and_get
6175: ( p_count => x_msg_count
6176: , p_data => x_msg_data);
6177: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6174: fnd_msg_pub.count_and_get

6170: l_msg := x_msg_data;
6171: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');
6172: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);
6173: FND_MSG_PUB.ADD;
6174: fnd_msg_pub.count_and_get
6175: ( p_count => x_msg_count
6176: , p_data => x_msg_data);
6177: x_return_status := FND_API.G_RET_STS_ERROR;
6178: po_moac_utils_pvt.set_org_context(l_current_org_id);

Line 6225: FND_MSG_PUB.ADD;

6221: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6222: l_msg := x_msg_data;
6223: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');
6224: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);
6225: FND_MSG_PUB.ADD;
6226: fnd_msg_pub.count_and_get
6227: ( p_count => x_msg_count
6228: , p_data => x_msg_data);
6229: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6226: fnd_msg_pub.count_and_get

6222: l_msg := x_msg_data;
6223: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');
6224: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);
6225: FND_MSG_PUB.ADD;
6226: fnd_msg_pub.count_and_get
6227: ( p_count => x_msg_count
6228: , p_data => x_msg_data);
6229: x_return_status := FND_API.G_RET_STS_ERROR;
6230: RAISE FND_API.G_EXC_ERROR;