DBA Data[Home] [Help]

APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on FND_MESSAGE

Line 369: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

365: ,X_MSG_DATA => x_MSG_DATA
366: ,X_RETURN_STATUS => x_RETURN_STATUS);
367: WHEN OTHERS THEN
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

Line 370: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);

366: ,X_RETURN_STATUS => x_RETURN_STATUS);
367: WHEN OTHERS THEN
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

Line 371: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);

367: WHEN OTHERS THEN
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);

Line 510: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INV_LOC_NOT_FOUND');

506: l_global_attribute20,
507: l_object_version_number;
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;

Line 511: FND_MESSAGE.SET_TOKEN('TSK_ASSGN_ID', p_location_id, TRUE);

507: l_object_version_number;
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;

Line 625: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

621: ,X_MSG_DATA => x_MSG_DATA
622: ,X_RETURN_STATUS => x_RETURN_STATUS);
623: WHEN OTHERS THEN
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

Line 626: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);

622: ,X_RETURN_STATUS => x_RETURN_STATUS);
623: WHEN OTHERS THEN
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

Line 627: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);

623: WHEN OTHERS THEN
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);

Line 814: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');

810: x_return_status => x_return_status);
811:
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;

Line 815: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);

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

Line 935: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');

931: x_return_status => x_return_status);
932:
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;

Line 936: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);

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

Line 974: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

970: ,X_MSG_DATA => x_MSG_DATA
971: ,X_RETURN_STATUS => x_RETURN_STATUS);
972: WHEN OTHERS THEN
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

Line 975: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);

971: ,X_RETURN_STATUS => x_RETURN_STATUS);
972: WHEN OTHERS THEN
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

Line 976: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);

972: WHEN OTHERS THEN
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);

Line 1604: /* FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');

1600: x_return_status => x_return_status);
1601:
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;

Line 1605: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);

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

Line 1844: /* FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');

1840: x_return_status => x_return_status);
1841:
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;

Line 1845: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);

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

Line 2081: /* FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');

2077: x_return_status => x_return_status);
2078:
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;

Line 2082: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);

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

Line 2125: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

2121: ,X_MSG_DATA => x_MSG_DATA
2122: ,X_RETURN_STATUS => x_RETURN_STATUS);
2123: WHEN OTHERS THEN
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

Line 2126: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

2122: ,X_RETURN_STATUS => x_RETURN_STATUS);
2123: WHEN OTHERS THEN
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

Line 2127: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

2123: WHEN OTHERS THEN
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);

Line 2619: FND_MESSAGE.SET_NAME ('CSP', 'CSP_TSK_ASSGN_ID_OR_ADDR_REQD');

2615: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','SHIP_TO_ADDRESS_HANDLER','B',x_return_status);
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:

Line 2736: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_STA_API_ERROR');

2732: END IF;
2733: l_inv_location_id := p_location_id;
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;

Line 2737: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);

2733: l_inv_location_id := p_location_id;
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:

Line 2759: FND_MESSAGE.SET_NAME ('CSP', 'CSP_RESOURCE_ID_MISSING');

2755: OPEN l_resource_id_csr;
2756: FETCH l_resource_id_csr INTO l_resource_type, l_resource_id;
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;

Line 2760: FND_MESSAGE.SET_TOKEN('TSK_ASSGN_ID', p_task_assignment_id, false);

2756: FETCH l_resource_id_csr INTO l_resource_type, l_resource_id;
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;

Line 2775: -- FND_MESSAGE.SET_NAME ('CSP', 'CSP_INV_LOC_MISSING');

2771: -- FETCH l_requirement_hdr_csr INTO l_inv_location_id;
2772: FETCH l_requirement_hdr_csr INTO t_inv_location_id, l_timezone_id;
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;

Line 2776: -- FND_MESSAGE.SET_TOKEN('TSK_ASSGN_ID', p_task_assignment_id, TRUE);

2772: FETCH l_requirement_hdr_csr INTO t_inv_location_id, l_timezone_id;
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;

Line 2795: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INV_LOC_MISSING');

2791: l_timezone_id := p_timezone;
2792: END IF;
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;

Line 2796: FND_MESSAGE.SET_TOKEN('TSK_ASSGN_ID', p_task_assignment_id, false);

2792: END IF;
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:

Line 2819: FND_MESSAGE.SET_NAME ('CSP', 'CSP_PARTY_ID_MISSING');

2815: OPEN l_party_id_csr;
2816: FETCH l_party_id_csr INTO l_party_id;
2817: IF l_party_id_csr%NOTFOUND THEN
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;

Line 2820: FND_MESSAGE.SET_TOKEN('RESOURCE_ID', l_resource_id, false);

2816: FETCH l_party_id_csr INTO l_party_id;
2817: IF l_party_id_csr%NOTFOUND THEN
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;

Line 2821: FND_MESSAGE.SET_TOKEN('CUST_ID', l_customer_id, false);

2817: IF l_party_id_csr%NOTFOUND THEN
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;

Line 2841: -- FND_MESSAGE.SET_NAME ('CSP', 'CSP_RESOURCE_NAME_MISSING');

2837: l_last_name := l_resource_name;
2838: END IF;
2839: IF l_resource_name_csr%NOTFOUND THEN
2840: -- CLOSE l_resource_name_csr;
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;

Line 2842: -- FND_MESSAGE.SET_TOKEN('TSK_ASSGN_ID', p_task_assignment_id, TRUE);

2838: END IF;
2839: IF l_resource_name_csr%NOTFOUND THEN
2840: -- CLOSE l_resource_name_csr;
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;

Line 2843: -- FND_MESSAGE.SET_TOKEN('RESOURCE_CODE', l_resource_type, TRUE);

2839: IF l_resource_name_csr%NOTFOUND THEN
2840: -- CLOSE l_resource_name_csr;
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);

Line 2844: -- FND_MESSAGE.SET_TOKEN('RESOURCE_ID', l_resource_id, TRUE);

2840: -- CLOSE l_resource_name_csr;
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;

Line 2951: /* FND_MESSAGE.SET_NAME ('CSP', 'CSP_PROF_API_ERROR');

2947: x_msg_data => x_msg_data);
2948:
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;

Line 2952: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);

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

Line 3206: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_CUST_API_ERROR');

3202: x_return_status => x_return_status);
3203:
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

Line 3207: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);

3203:
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.

Line 3226: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INV_LOC_NOT_FOUND');

3222: s_global_attribute8, s_global_attribute9, s_global_attribute10, s_global_attribute11, s_global_attribute12, s_global_attribute13, s_global_attribute14,
3223: s_global_attribute15, s_global_attribute16, s_global_attribute17, s_global_attribute18, s_global_attribute19, s_global_attribute20;
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;

Line 3227: FND_MESSAGE.SET_TOKEN ('LOC_ID', 'l_inv_location_id',false);

3223: s_global_attribute15, s_global_attribute16, s_global_attribute17, s_global_attribute18, s_global_attribute19, s_global_attribute20;
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;

Line 3276: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INV_LOC_HAS_ASSIGNED');

3272: t_loc_last_update_date;
3273: IF l_po_loc_association_csr%FOUND THEN
3274: CLOSE l_po_loc_association_csr;
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;

Line 3277: FND_MESSAGE.SET_TOKEN ('LOC_ID', 'l_inv_location_id',false);

3273: IF l_po_loc_association_csr%FOUND THEN
3274: CLOSE l_po_loc_association_csr;
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

Line 3278: FND_MESSAGE.SET_TOKEN ('CUSTOMER_ID', 't_customer_id',false);

3274: CLOSE l_po_loc_association_csr;
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

Line 3311: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');

3307: END IF;
3308:
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;

Line 3312: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);

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

Line 3413: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_ADDR_API_ERROR');

3409: x_return_status => x_return_status);
3410:
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;

Line 3414: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);

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

Line 3513: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_ADDR_API_ERROR');

3509: x_return_status => x_return_status);
3510:
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;

Line 3514: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);

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

Line 3532: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');

3528: END IF;
3529:
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;

Line 3533: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);

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

Line 3670: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_ADDR_API_ERROR');

3666: x_return_status => x_return_status);
3667:
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;

Line 3671: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);

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

Line 3695: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_API_ERROR');

3691: x_msg_data => x_msg_data);
3692:
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;

Line 3696: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);

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

Line 3758: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

3754: ,X_MSG_DATA => X_MSG_DATA
3755: ,X_RETURN_STATUS => X_RETURN_STATUS);
3756: WHEN OTHERS THEN
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

Line 3759: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);

3755: ,X_RETURN_STATUS => X_RETURN_STATUS);
3756: WHEN OTHERS THEN
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

Line 3760: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);

3756: WHEN OTHERS THEN
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);

Line 3856: FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_ID_REQD');

3852: x_return_status := FND_API.G_RET_STS_SUCCESS;
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:

Line 3916: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_STA_API_ERROR');

3912:
3913: l_inv_loc_id := p_location_id;
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

Line 3917: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);

3913: l_inv_loc_id := p_location_id;
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:

Line 3933: FND_MESSAGE.SET_NAME ('CSP', 'CSP_ADDRESS_REQD');

3929:
3930: END IF;
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;

Line 3934: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data,false);

3930: END IF;
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:

Line 3965: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

3961: ,X_MSG_DATA => x_MSG_DATA
3962: ,X_RETURN_STATUS => x_RETURN_STATUS);
3963: WHEN OTHERS THEN
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

Line 3966: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);

3962: ,X_RETURN_STATUS => x_RETURN_STATUS);
3963: WHEN OTHERS THEN
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

Line 3967: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);

3963: WHEN OTHERS THEN
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);

Line 4075: FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_ID_REQD');

4071: x_return_status := FND_API.G_RET_STS_SUCCESS;
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

Line 4142: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_STA_API_ERROR');

4138:
4139: l_inv_loc_id := p_location_id;
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

Line 4143: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);

4139: l_inv_loc_id := p_location_id;
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:

Line 4159: FND_MESSAGE.SET_NAME ('CSP', 'CSP_ADDRESS_REQD');

4155:
4156: END IF;
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;

Line 4160: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);

4156: END IF;
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

Line 4173: csp_location_rec.ADDRESS_LINE_1 := FND_MESSAGE.GET_STRING('CSP', 'CSP_ADDRESS_DESC');

4169: OPEN get_country_location;
4170: FETCH get_country_location INTO csp_location_rec;
4171: CLOSE get_country_location;
4172: END IF;
4173: csp_location_rec.ADDRESS_LINE_1 := FND_MESSAGE.GET_STRING('CSP', 'CSP_ADDRESS_DESC');
4174:
4175: -- If address fields are not null, create a new inventory location. Otherwise, return error.
4176: IF p_country IS NOT NULL THEN
4177: do_create_ship_to_location(

Line 4231: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_STA_API_ERROR');

4227:
4228: l_inv_loc_id := p_location_id;
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

Line 4232: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);

4228: l_inv_loc_id := p_location_id;
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:

Line 4248: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_ADDRESS_REQD');

4244:
4245: END IF;
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;

Line 4249: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);

4245: END IF;
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;

Line 4280: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

4276: ,X_MSG_DATA => x_MSG_DATA
4277: ,X_RETURN_STATUS => x_RETURN_STATUS);
4278: WHEN OTHERS THEN
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

Line 4281: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

4277: ,X_RETURN_STATUS => x_RETURN_STATUS);
4278: WHEN OTHERS THEN
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

Line 4282: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

4278: WHEN OTHERS THEN
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);

Line 4326: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');

4322: DBMS_SQL.close_cursor (v_cursorid);
4323:
4324: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
4325: THEN
4326: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');
4327: fnd_message.set_token (
4328: 'P_PROCEDURE',
4329: i.hook_package || '.' || i.hook_api,false
4330: );

Line 4327: fnd_message.set_token (

4323:
4324: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
4325: THEN
4326: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');
4327: fnd_message.set_token (
4328: 'P_PROCEDURE',
4329: i.hook_package || '.' || i.hook_api,false
4330: );
4331: fnd_msg_pub.add;

Line 4340: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');

4336: END IF;
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;

Line 4352: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

4348: THEN
4349: x_return_status := fnd_api.g_ret_sts_unexp_error;
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;

Line 4353: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM,false);

4349: x_return_status := fnd_api.g_ret_sts_unexp_error;
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:

Line 4591: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

4587: ,X_MSG_DATA => X_MSG_DATA
4588: ,X_RETURN_STATUS => X_RETURN_STATUS);
4589: WHEN OTHERS THEN
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

Line 4592: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, false);

4588: ,X_RETURN_STATUS => X_RETURN_STATUS);
4589: WHEN OTHERS THEN
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

Line 4593: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, false);

4589: WHEN OTHERS THEN
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);