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 332: fnd_msg_pub.count_and_get

328: p_attribute20 => p_attribute20,
329: p_attribute_category => p_attribute_category
330: );
331:
332: fnd_msg_pub.count_and_get
333: ( p_count => x_msg_count
334: , p_data => x_msg_data);
335:
336: -- Exception Block

Line 344: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

340: x_return_status := FND_API.G_RET_STS_ERROR;
341: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
342: P_API_NAME => L_API_NAME
343: ,P_PKG_NAME => G_PKG_NAME
344: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
345: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
346: ,X_MSG_COUNT => x_MSG_COUNT
347: ,X_MSG_DATA => x_MSG_DATA
348: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 353: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

349: WHEN FND_API.G_EXC_ERROR THEN
350: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
351: P_API_NAME => L_API_NAME
352: ,P_PKG_NAME => G_PKG_NAME
353: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
354: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
355: ,X_MSG_COUNT => x_MSG_COUNT
356: ,X_MSG_DATA => x_MSG_DATA
357: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 362: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
360: P_API_NAME => L_API_NAME
361: ,P_PKG_NAME => G_PKG_NAME
362: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
363: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
364: ,X_MSG_COUNT => x_MSG_COUNT
365: ,X_MSG_DATA => x_MSG_DATA
366: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 372: FND_MSG_PUB.ADD;

368: Rollback to do_create_ship_to_location_PUB;
369: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
370: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
371: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
372: FND_MSG_PUB.ADD;
373: fnd_msg_pub.count_and_get
374: ( p_count => x_msg_count
375: , p_data => x_msg_data);
376: x_return_status := FND_API.G_RET_STS_ERROR;

Line 373: fnd_msg_pub.count_and_get

369: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
370: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
371: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
372: FND_MSG_PUB.ADD;
373: fnd_msg_pub.count_and_get
374: ( p_count => x_msg_count
375: , p_data => x_msg_data);
376: x_return_status := FND_API.G_RET_STS_ERROR;
377:

Line 512: FND_MSG_PUB.ADD;

508: IF l_inv_location_csr%NOTFOUND THEN
509: CLOSE l_inv_location_csr;
510: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INV_LOC_NOT_FOUND');
511: FND_MESSAGE.SET_TOKEN('TSK_ASSGN_ID', p_location_id, TRUE);
512: FND_MSG_PUB.ADD;
513: RAISE EXCP_USER_DEFINED;
514: END IF;
515: CLOSE l_inv_location_csr;
516:

Line 588: fnd_msg_pub.count_and_get

584: p_attribute_category => p_attribute_category
585: );
586:
587: p_object_version_number := l_object_version_number;
588: fnd_msg_pub.count_and_get
589: ( p_count => x_msg_count
590: , p_data => x_msg_data);
591:
592: -- Exception Block

Line 600: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

596: x_return_status := FND_API.G_RET_STS_ERROR;
597: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
598: P_API_NAME => L_API_NAME
599: ,P_PKG_NAME => G_PKG_NAME
600: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
601: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
602: ,X_MSG_COUNT => x_MSG_COUNT
603: ,X_MSG_DATA => x_MSG_DATA
604: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 609: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

605: WHEN FND_API.G_EXC_ERROR THEN
606: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
607: P_API_NAME => L_API_NAME
608: ,P_PKG_NAME => G_PKG_NAME
609: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
610: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
611: ,X_MSG_COUNT => x_MSG_COUNT
612: ,X_MSG_DATA => x_MSG_DATA
613: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 618: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
615: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
616: P_API_NAME => L_API_NAME
617: ,P_PKG_NAME => G_PKG_NAME
618: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
619: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
620: ,X_MSG_COUNT => x_MSG_COUNT
621: ,X_MSG_DATA => x_MSG_DATA
622: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 628: FND_MSG_PUB.ADD;

624: Rollback to do_update_ship_to_location_PUB;
625: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
626: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
627: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
628: FND_MSG_PUB.ADD;
629: fnd_msg_pub.count_and_get
630: ( p_count => x_msg_count
631: , p_data => x_msg_data);
632: x_return_status := FND_API.G_RET_STS_ERROR;

Line 629: fnd_msg_pub.count_and_get

625: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
626: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
627: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
628: FND_MSG_PUB.ADD;
629: fnd_msg_pub.count_and_get
630: ( p_count => x_msg_count
631: , p_data => x_msg_data);
632: x_return_status := FND_API.G_RET_STS_ERROR;
633:

Line 816: FND_MSG_PUB.ADD;*/

812: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
813: Rollback to do_create_site_use_PUB;
814: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');
815: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
816: FND_MSG_PUB.ADD;*/
817: RAISE EXCP_USER_DEFINED;
818: END IF;
819:
820: s_location_id := null;

Line 937: FND_MSG_PUB.ADD;*/

933: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
934: Rollback to do_create_site_use_PUB;
935: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');
936: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
937: FND_MSG_PUB.ADD;*/
938: RAISE EXCP_USER_DEFINED;
939: END IF;
940:
941: -- Exception Block

Line 949: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

945: x_return_status := FND_API.G_RET_STS_ERROR;
946: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
947: P_API_NAME => L_API_NAME
948: ,P_PKG_NAME => G_PKG_NAME
949: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
950: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
951: ,X_MSG_COUNT => x_MSG_COUNT
952: ,X_MSG_DATA => x_MSG_DATA
953: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 958: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

954: WHEN FND_API.G_EXC_ERROR THEN
955: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
956: P_API_NAME => L_API_NAME
957: ,P_PKG_NAME => G_PKG_NAME
958: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
959: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
960: ,X_MSG_COUNT => x_MSG_COUNT
961: ,X_MSG_DATA => x_MSG_DATA
962: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 967: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
964: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
965: P_API_NAME => L_API_NAME
966: ,P_PKG_NAME => G_PKG_NAME
967: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
968: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
969: ,X_MSG_COUNT => x_MSG_COUNT
970: ,X_MSG_DATA => x_MSG_DATA
971: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 977: FND_MSG_PUB.ADD;

973: Rollback to do_create_site_use_PUB;
974: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
975: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
976: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
977: FND_MSG_PUB.ADD;
978: fnd_msg_pub.count_and_get
979: ( p_count => x_msg_count
980: , p_data => x_msg_data);
981: x_return_status := FND_API.G_RET_STS_ERROR;

Line 978: fnd_msg_pub.count_and_get

974: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
975: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
976: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
977: FND_MSG_PUB.ADD;
978: fnd_msg_pub.count_and_get
979: ( p_count => x_msg_count
980: , p_data => x_msg_data);
981: x_return_status := FND_API.G_RET_STS_ERROR;
982:

Line 1606: FND_MSG_PUB.ADD;*/

1602: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1603: Rollback to do_update_site_use_PUB;
1604: /* FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');
1605: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
1606: FND_MSG_PUB.ADD;*/
1607: RAISE EXCP_USER_DEFINED;
1608: END IF;
1609: ELSE
1610: close l_cust_Bill_to_site_use_csr;

Line 1846: FND_MSG_PUB.ADD;*/

1842: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1843: Rollback to do_update_site_use_PUB;
1844: /* FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');
1845: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
1846: FND_MSG_PUB.ADD;*/
1847: RAISE EXCP_USER_DEFINED;
1848: END IF;
1849: ELSE
1850: close l_cust_site_use_csr;

Line 2083: FND_MSG_PUB.ADD;*/

2079: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2080: Rollback to do_update_site_use_PUB;
2081: /* FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');
2082: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
2083: FND_MSG_PUB.ADD;*/
2084: RAISE EXCP_USER_DEFINED;
2085: END IF;
2086: ELSE
2087: close l_cust_Bill_to_site_use_csr;

Line 2100: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2096: x_return_status := FND_API.G_RET_STS_ERROR;
2097: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2098: P_API_NAME => L_API_NAME
2099: ,P_PKG_NAME => G_PKG_NAME
2100: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2101: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2102: ,X_MSG_COUNT => x_MSG_COUNT
2103: ,X_MSG_DATA => x_MSG_DATA
2104: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 2109: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2105: WHEN FND_API.G_EXC_ERROR THEN
2106: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2107: P_API_NAME => L_API_NAME
2108: ,P_PKG_NAME => G_PKG_NAME
2109: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2110: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2111: ,X_MSG_COUNT => x_MSG_COUNT
2112: ,X_MSG_DATA => x_MSG_DATA
2113: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 2118: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2115: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2116: P_API_NAME => L_API_NAME
2117: ,P_PKG_NAME => G_PKG_NAME
2118: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2119: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2120: ,X_MSG_COUNT => x_MSG_COUNT
2121: ,X_MSG_DATA => x_MSG_DATA
2122: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 2128: FND_MSG_PUB.ADD;

2124: Rollback to do_update_site_use_PUB;
2125: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2126: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2127: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2128: FND_MSG_PUB.ADD;
2129: fnd_msg_pub.count_and_get
2130: ( p_count => x_msg_count
2131: , p_data => x_msg_data);
2132: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2129: fnd_msg_pub.count_and_get

2125: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2126: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2127: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2128: FND_MSG_PUB.ADD;
2129: fnd_msg_pub.count_and_get
2130: ( p_count => x_msg_count
2131: , p_data => x_msg_data);
2132: x_return_status := FND_API.G_RET_STS_ERROR;
2133:

Line 2603: FND_MSG_PUB.initialize;

2599: BEGIN
2600: SAVEPOINT ship_to_address_handler_PUB;
2601:
2602: -- initialize message list
2603: FND_MSG_PUB.initialize;
2604:
2605: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2606: p_api_version_number,
2607: l_api_name,

Line 2620: FND_MSG_PUB.ADD;

2616:
2617: -- If task assignment id and addresses are both null, return error.
2618: IF (p_task_assignment_id IS NULL) and (p_country IS NULL) THEN
2619: FND_MESSAGE.SET_NAME ('CSP', 'CSP_TSK_ASSGN_ID_OR_ADDR_REQD');
2620: FND_MSG_PUB.ADD;
2621: RAISE EXCP_USER_DEFINED;
2622: END IF;
2623:
2624:

Line 2738: FND_MSG_PUB.ADD;*/

2734: IF x_return_status in ('E','U') THEN
2735: Rollback to ship_to_address_handler_PUB;
2736: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_STA_API_ERROR');
2737: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
2738: FND_MSG_PUB.ADD;*/
2739: RAISE EXCP_USER_DEFINED;
2740: END IF;
2741:
2742: END;

Line 2761: FND_MSG_PUB.ADD;

2757: IF l_resource_id_csr%NOTFOUND THEN
2758: CLOSE l_resource_id_csr;
2759: FND_MESSAGE.SET_NAME ('CSP', 'CSP_RESOURCE_ID_MISSING');
2760: FND_MESSAGE.SET_TOKEN('TSK_ASSGN_ID', p_task_assignment_id, false);
2761: FND_MSG_PUB.ADD;
2762: RAISE EXCP_USER_DEFINED;
2763: END IF;
2764: CLOSE l_resource_id_csr;
2765: END IF;

Line 2777: -- FND_MSG_PUB.ADD;

2773: IF l_requirement_hdr_csr%NOTFOUND THEN
2774: CLOSE l_requirement_hdr_csr;
2775: -- FND_MESSAGE.SET_NAME ('CSP', 'CSP_INV_LOC_MISSING');
2776: -- FND_MESSAGE.SET_TOKEN('TSK_ASSGN_ID', p_task_assignment_id, TRUE);
2777: -- FND_MSG_PUB.ADD;
2778: -- RAISE EXCP_USER_DEFINED;
2779: t_inv_location_id := null;
2780: l_timezone_id := null;
2781: ELSE

Line 2797: FND_MSG_PUB.ADD;

2793:
2794: IF l_inv_location_id IS NULL THEN
2795: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INV_LOC_MISSING');
2796: FND_MESSAGE.SET_TOKEN('TSK_ASSGN_ID', p_task_assignment_id, false);
2797: FND_MSG_PUB.ADD;
2798: RAISE EXCP_USER_DEFINED;
2799: END IF;
2800:
2801: -- Get party_id if it exists for this resource

Line 2822: FND_MSG_PUB.ADD;

2818: CLOSE l_party_id_csr;
2819: FND_MESSAGE.SET_NAME ('CSP', 'CSP_PARTY_ID_MISSING');
2820: FND_MESSAGE.SET_TOKEN('RESOURCE_ID', l_resource_id, false);
2821: FND_MESSAGE.SET_TOKEN('CUST_ID', l_customer_id, false);
2822: FND_MSG_PUB.ADD;
2823: RAISE EXCP_USER_DEFINED;
2824: END IF;
2825: CLOSE l_party_id_csr;
2826:

Line 2845: -- FND_MSG_PUB.ADD;

2841: -- FND_MESSAGE.SET_NAME ('CSP', 'CSP_RESOURCE_NAME_MISSING');
2842: -- FND_MESSAGE.SET_TOKEN('TSK_ASSGN_ID', p_task_assignment_id, TRUE);
2843: -- FND_MESSAGE.SET_TOKEN('RESOURCE_CODE', l_resource_type, TRUE);
2844: -- FND_MESSAGE.SET_TOKEN('RESOURCE_ID', l_resource_id, TRUE);
2845: -- FND_MSG_PUB.ADD;
2846: -- RAISE EXCP_USER_DEFINED;
2847: l_resource_name := csp_pick_utils.get_object_name(l_resource_type, l_resource_id);
2848: l_first_name := l_resource_name;
2849: l_last_name := l_resource_name;

Line 2953: FND_MSG_PUB.ADD;*/

2949: IF x_return_status in ('E','U') THEN
2950: Rollback to ship_to_address_handler_PUB;
2951: /* FND_MESSAGE.SET_NAME ('CSP', 'CSP_PROF_API_ERROR');
2952: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
2953: FND_MSG_PUB.ADD;*/
2954: RAISE EXCP_USER_DEFINED;
2955: END IF;
2956:
2957: -- if auto generate customer number is no, pass the customer number to the API

Line 3208: FND_MSG_PUB.ADD;*/

3204: IF x_return_status in ('E','U') THEN
3205: Rollback to ship_to_address_handler_PUB;
3206: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_CUST_API_ERROR');
3207: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
3208: FND_MSG_PUB.ADD;*/
3209: RAISE EXCP_USER_DEFINED;
3210: ELSE
3211: -- Create/update resource customer relationship in csp_rs_cust_relations.
3212: do_rs_cust_relations(l_resource_type, l_resource_id, l_customer_id);

Line 3228: FND_MSG_PUB.ADD;

3224: IF l_inv_loc_csr%NOTFOUND THEN
3225: CLOSE l_inv_loc_csr;
3226: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INV_LOC_NOT_FOUND');
3227: FND_MESSAGE.SET_TOKEN ('LOC_ID', 'l_inv_location_id',false);
3228: FND_MSG_PUB.ADD;
3229: RAISE EXCP_USER_DEFINED;
3230: END IF;
3231: CLOSE l_inv_loc_csr;
3232: /* As part of bug fix following code is included for canadian address ,

Line 3279: FND_MSG_PUB.ADD;

3275: IF t_customer_id <> l_customer_id THEN
3276: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INV_LOC_HAS_ASSIGNED');
3277: FND_MESSAGE.SET_TOKEN ('LOC_ID', 'l_inv_location_id',false);
3278: FND_MESSAGE.SET_TOKEN ('CUSTOMER_ID', 't_customer_id',false);
3279: FND_MSG_PUB.ADD;
3280: RAISE EXCP_USER_DEFINED;
3281: ELSE
3282: IF p_status IS NOT NULL THEN
3283: t_status := p_status;

Line 3313: FND_MSG_PUB.ADD;*/

3309: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3310: Rollback to ship_to_address_handler_PUB;
3311: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');
3312: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
3313: FND_MSG_PUB.ADD;*/
3314: RAISE EXCP_USER_DEFINED;
3315: END IF;
3316:
3317:

Line 3415: FND_MSG_PUB.ADD;*/

3411: IF x_return_status in ('E','U') THEN
3412: Rollback to ship_to_address_handler_PUB;
3413: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_ADDR_API_ERROR');
3414: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
3415: FND_MSG_PUB.ADD;*/
3416: RAISE EXCP_USER_DEFINED;
3417: END IF;
3418: ELSE
3419: arh_addr_pkg.update_row (

Line 3515: FND_MSG_PUB.ADD;*/

3511: IF x_return_status in ('E','U') THEN
3512: Rollback to ship_to_address_handler_PUB;
3513: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_ADDR_API_ERROR');
3514: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
3515: FND_MSG_PUB.ADD;*/
3516: RAISE EXCP_USER_DEFINED;
3517: END IF;
3518: IF p_primary_flag IS NOT NULL or p_status IS NOT NULL THEN
3519: do_update_site_use

Line 3534: FND_MSG_PUB.ADD;*/

3530: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3531: Rollback to ship_to_address_handler_PUB;
3532: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');
3533: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
3534: FND_MSG_PUB.ADD;*/
3535: RAISE EXCP_USER_DEFINED;
3536: END IF;
3537:
3538: END IF;

Line 3672: FND_MSG_PUB.ADD;*/

3668: IF x_return_status in ('E','U') THEN
3669: Rollback to ship_to_address_handler_PUB;
3670: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_ADDR_API_ERROR');
3671: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
3672: FND_MSG_PUB.ADD;*/
3673: RAISE EXCP_USER_DEFINED;
3674: END IF;
3675:
3676: IF l_timezone_id IS NOT NULL THEN

Line 3697: FND_MSG_PUB.ADD;*/

3693: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3694: Rollback to ship_to_address_handler_PUB;
3695: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');
3696: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
3697: FND_MSG_PUB.ADD;*/
3698: RAISE EXCP_USER_DEFINED;
3699: END IF;
3700: END IF;
3701: END;

Line 3721: fnd_msg_pub.count_and_get

3717: IF p_commit = FND_API.G_TRUE THEN
3718: COMMIT;
3719: END IF;
3720:
3721: fnd_msg_pub.count_and_get
3722: ( p_count => x_msg_count
3723: , p_data => x_msg_data);
3724:
3725: -- Exception Block --

Line 3733: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3729: x_return_status := FND_API.G_RET_STS_ERROR;
3730: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3731: P_API_NAME => L_API_NAME
3732: ,P_PKG_NAME => G_PKG_NAME
3733: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3734: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
3735: ,X_MSG_COUNT => X_MSG_COUNT
3736: ,X_MSG_DATA => X_MSG_DATA
3737: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3742: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3738: WHEN FND_API.G_EXC_ERROR THEN
3739: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3740: P_API_NAME => L_API_NAME
3741: ,P_PKG_NAME => G_PKG_NAME
3742: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3743: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
3744: ,X_MSG_COUNT => X_MSG_COUNT
3745: ,X_MSG_DATA => X_MSG_DATA
3746: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3751: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3748: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3749: P_API_NAME => L_API_NAME
3750: ,P_PKG_NAME => G_PKG_NAME
3751: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3752: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
3753: ,X_MSG_COUNT => X_MSG_COUNT
3754: ,X_MSG_DATA => X_MSG_DATA
3755: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3761: FND_MSG_PUB.ADD;

3757: Rollback to ship_to_address_handler_PUB;
3758: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3759: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
3760: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
3761: FND_MSG_PUB.ADD;
3762: fnd_msg_pub.count_and_get
3763: ( p_count => x_msg_count
3764: , p_data => x_msg_data);
3765: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3762: fnd_msg_pub.count_and_get

3758: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3759: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
3760: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
3761: FND_MSG_PUB.ADD;
3762: fnd_msg_pub.count_and_get
3763: ( p_count => x_msg_count
3764: , p_data => x_msg_data);
3765: x_return_status := FND_API.G_RET_STS_ERROR;
3766:

Line 3843: FND_MSG_PUB.initialize;

3839: BEGIN
3840: SAVEPOINT site_to_invloc_linkage_PUB;
3841:
3842: -- initialize message list
3843: FND_MSG_PUB.initialize;
3844:
3845: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3846: p_api_version_number,
3847: l_api_name,

Line 3857: FND_MSG_PUB.ADD;

3853:
3854: -- If site use id is null, return error.
3855: IF p_site_use_id IS NULL THEN
3856: FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_ID_REQD');
3857: FND_MSG_PUB.ADD;
3858: RAISE EXCP_USER_DEFINED;
3859: END IF;
3860:
3861: -- If address fields are not null, create a new inventory location. Otherwise, return error.

Line 3918: FND_MSG_PUB.ADD;*/

3914: IF x_return_status in ('E','U') THEN
3915: Rollback to site_to_invloc_linkage_PUB;
3916: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_STA_API_ERROR');
3917: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
3918: FND_MSG_PUB.ADD;*/
3919: /* RAISE EXCP_USER_DEFINED;
3920: ELSE
3921:
3922: -- Create the linkage between the site use and the inventory location.

Line 3935: FND_MSG_PUB.ADD;

3931: ELSE
3932: Rollback to site_to_invloc_linkage_PUB;
3933: FND_MESSAGE.SET_NAME ('CSP', 'CSP_ADDRESS_REQD');
3934: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data,false);
3935: FND_MSG_PUB.ADD;
3936: RAISE EXCP_USER_DEFINED;
3937: END IF;
3938:
3939: EXCEPTION

Line 3942: fnd_msg_pub.count_and_get

3938:
3939: EXCEPTION
3940: WHEN EXCP_USER_DEFINED THEN
3941: x_return_status := FND_API.G_RET_STS_ERROR;
3942: fnd_msg_pub.count_and_get
3943: ( p_count => x_msg_count
3944: , p_data => x_msg_data);
3945: WHEN FND_API.G_EXC_ERROR THEN
3946: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 3949: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3945: WHEN FND_API.G_EXC_ERROR THEN
3946: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3947: P_API_NAME => L_API_NAME
3948: ,P_PKG_NAME => G_PKG_NAME
3949: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3950: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
3951: ,X_MSG_COUNT => x_MSG_COUNT
3952: ,X_MSG_DATA => x_MSG_DATA
3953: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 3958: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3955: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3956: P_API_NAME => L_API_NAME
3957: ,P_PKG_NAME => G_PKG_NAME
3958: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3959: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
3960: ,X_MSG_COUNT => x_MSG_COUNT
3961: ,X_MSG_DATA => x_MSG_DATA
3962: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 3968: FND_MSG_PUB.ADD;

3964: Rollback to site_to_invloc_linkage_PUB;
3965: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3966: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
3967: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
3968: FND_MSG_PUB.ADD;
3969: fnd_msg_pub.count_and_get
3970: ( p_count => x_msg_count
3971: , p_data => x_msg_data);
3972: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3969: fnd_msg_pub.count_and_get

3965: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3966: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
3967: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
3968: FND_MSG_PUB.ADD;
3969: fnd_msg_pub.count_and_get
3970: ( p_count => x_msg_count
3971: , p_data => x_msg_data);
3972: x_return_status := FND_API.G_RET_STS_ERROR;
3973:

Line 4062: FND_MSG_PUB.initialize;

4058: BEGIN
4059: SAVEPOINT site_to_invloc_linkage_PUB;
4060:
4061: -- initialize message list
4062: FND_MSG_PUB.initialize;
4063:
4064: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4065: p_api_version_number,
4066: l_api_name,

Line 4076: FND_MSG_PUB.ADD;

4072:
4073: -- If site use id is null, return error.
4074: IF p_site_use_id IS NULL THEN
4075: FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_ID_REQD');
4076: FND_MSG_PUB.ADD;
4077: RAISE EXCP_USER_DEFINED;
4078: END IF;
4079: IF fnd_profile.value('CSP_INTRANSIT_LOCATION_USED') = 'Y' THEN
4080: -- If address fields are not null, create a new inventory location. Otherwise, return error.

Line 4144: FND_MSG_PUB.ADD;*/

4140: IF x_return_status in ('E','U') THEN
4141: Rollback to site_to_invloc_linkage_PUB;
4142: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_STA_API_ERROR');
4143: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
4144: FND_MSG_PUB.ADD;*/
4145: RAISE EXCP_USER_DEFINED;
4146: ELSE
4147:
4148: -- Create the linkage between the site use and the inventory location.

Line 4161: FND_MSG_PUB.ADD;

4157: ELSE
4158: Rollback to site_to_invloc_linkage_PUB;
4159: FND_MESSAGE.SET_NAME ('CSP', 'CSP_ADDRESS_REQD');
4160: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
4161: FND_MSG_PUB.ADD;
4162: RAISE EXCP_USER_DEFINED;
4163: END IF;
4164: ELSE
4165: OPEN get_csp_location;

Line 4233: FND_MSG_PUB.ADD;*/

4229: IF x_return_status in ('E','U') THEN
4230: Rollback to site_to_invloc_linkage_PUB;
4231: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_STA_API_ERROR');
4232: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
4233: FND_MSG_PUB.ADD;*/
4234: RAISE EXCP_USER_DEFINED;
4235: ELSE
4236:
4237: -- Create the linkage between the site use and the inventory location.

Line 4250: FND_MSG_PUB.ADD;*/

4246: ELSE
4247: Rollback to site_to_invloc_linkage_PUB;
4248: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_ADDRESS_REQD');
4249: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
4250: FND_MSG_PUB.ADD;*/
4251: RAISE EXCP_USER_DEFINED;
4252: END IF;
4253: END IF;
4254: EXCEPTION

Line 4257: fnd_msg_pub.count_and_get

4253: END IF;
4254: EXCEPTION
4255: WHEN EXCP_USER_DEFINED THEN
4256: x_return_status := FND_API.G_RET_STS_ERROR;
4257: fnd_msg_pub.count_and_get
4258: ( p_count => x_msg_count
4259: , p_data => x_msg_data);
4260: WHEN FND_API.G_EXC_ERROR THEN
4261: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 4264: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4260: WHEN FND_API.G_EXC_ERROR THEN
4261: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4262: P_API_NAME => L_API_NAME
4263: ,P_PKG_NAME => G_PKG_NAME
4264: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4265: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4266: ,X_MSG_COUNT => x_MSG_COUNT
4267: ,X_MSG_DATA => x_MSG_DATA
4268: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 4273: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4270: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4271: P_API_NAME => L_API_NAME
4272: ,P_PKG_NAME => G_PKG_NAME
4273: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4274: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4275: ,X_MSG_COUNT => x_MSG_COUNT
4276: ,X_MSG_DATA => x_MSG_DATA
4277: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 4283: FND_MSG_PUB.ADD;

4279: Rollback to site_to_invloc_linkage_PUB;
4280: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4281: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
4282: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
4283: FND_MSG_PUB.ADD;
4284: fnd_msg_pub.count_and_get
4285: ( p_count => x_msg_count
4286: , p_data => x_msg_data);
4287: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4284: fnd_msg_pub.count_and_get

4280: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4281: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
4282: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
4283: FND_MSG_PUB.ADD;
4284: fnd_msg_pub.count_and_get
4285: ( p_count => x_msg_count
4286: , p_data => x_msg_data);
4287: x_return_status := FND_API.G_RET_STS_ERROR;
4288:

Line 4331: fnd_msg_pub.add;

4327: fnd_message.set_token (
4328: 'P_PROCEDURE',
4329: i.hook_package || '.' || i.hook_api,false
4330: );
4331: fnd_msg_pub.add;
4332: x_return_status := fnd_api.g_ret_sts_unexp_error;
4333: RAISE fnd_api.g_exc_unexpected_error;
4334: x_return_status := fnd_api.g_ret_sts_unexp_error;
4335: RAISE fnd_api.g_exc_unexpected_error;

Line 4341: fnd_msg_pub.add;

4337:
4338: IF x_return_status IS NULL
4339: THEN
4340: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');
4341: fnd_msg_pub.add;
4342: x_return_status := fnd_api.g_ret_sts_unexp_error;
4343: RAISE fnd_api.g_exc_unexpected_error;
4344: END IF;
4345: END LOOP;

Line 4354: fnd_msg_pub.add;

4350: WHEN OTHERS
4351: THEN
4352: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4353: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM,false);
4354: fnd_msg_pub.add;
4355: x_return_status := fnd_api.g_ret_sts_unexp_error;
4356: END;
4357:
4358: PROCEDURE cust_inv_loc_link

Line 4575: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4571: WHEN FND_API.G_EXC_ERROR THEN
4572: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4573: P_API_NAME => L_API_NAME
4574: ,P_PKG_NAME => G_PKG_NAME
4575: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4576: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4577: ,X_MSG_COUNT => X_MSG_COUNT
4578: ,X_MSG_DATA => X_MSG_DATA
4579: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4584: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4581: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4582: P_API_NAME => L_API_NAME
4583: ,P_PKG_NAME => G_PKG_NAME
4584: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4585: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4586: ,X_MSG_COUNT => X_MSG_COUNT
4587: ,X_MSG_DATA => X_MSG_DATA
4588: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4594: FND_MSG_PUB.ADD;

4590: Rollback to cust_inv_loc_link_pub;
4591: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4592: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
4593: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
4594: FND_MSG_PUB.ADD;
4595: fnd_msg_pub.count_and_get
4596: ( p_count => x_msg_count
4597: , p_data => x_msg_data);
4598: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4595: fnd_msg_pub.count_and_get

4591: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4592: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);
4593: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);
4594: FND_MSG_PUB.ADD;
4595: fnd_msg_pub.count_and_get
4596: ( p_count => x_msg_count
4597: , p_data => x_msg_data);
4598: x_return_status := FND_API.G_RET_STS_ERROR;
4599: