DBA Data[Home] [Help]

APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on FND_MESSAGE

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

845: 'sqlerrm = ' || sqlerrm);
846: end if;
847:
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

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

846: end if;
847:
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

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

847:
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);

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

986: l_global_attribute20,
987: l_object_version_number;
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;

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

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

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

1101: ,X_MSG_DATA => x_MSG_DATA
1102: ,X_RETURN_STATUS => x_RETURN_STATUS);
1103: WHEN OTHERS THEN
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

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

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

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

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

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

1312: x_return_status => x_return_status);
1313:
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;

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

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

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

1433: x_return_status => x_return_status);
1434:
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;

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

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

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

1472: ,X_MSG_DATA => x_MSG_DATA
1473: ,X_RETURN_STATUS => x_RETURN_STATUS);
1474: WHEN OTHERS THEN
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

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

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

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

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

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

2102: x_return_status => x_return_status);
2103:
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;

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

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

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

2342: x_return_status => x_return_status);
2343:
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;

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

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

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

2579: x_return_status => x_return_status);
2580:
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;

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

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

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

2623: ,X_MSG_DATA => x_MSG_DATA
2624: ,X_RETURN_STATUS => x_RETURN_STATUS);
2625: WHEN OTHERS THEN
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

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

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

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

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

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

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

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

3277: END IF;
3278: l_inv_location_id := p_location_id;
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;

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

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

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

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

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

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

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

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

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

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

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

3336: l_timezone_id := p_timezone;
3337: END IF;
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;

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

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

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

3370: OPEN l_party_id_csr;
3371: FETCH l_party_id_csr INTO l_party_id;
3372: IF l_party_id_csr%NOTFOUND THEN
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;

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

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

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

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

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

3392: l_last_name := l_resource_name;
3393: END IF;
3394: IF l_resource_name_csr%NOTFOUND THEN
3395: -- CLOSE l_resource_name_csr;
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;

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

3393: END IF;
3394: IF l_resource_name_csr%NOTFOUND THEN
3395: -- CLOSE l_resource_name_csr;
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;

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

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

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

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

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

3502: x_msg_data => x_msg_data);
3503:
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;

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

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

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

3757: x_return_status => x_return_status);
3758:
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

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

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

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

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

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

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

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

3830: t_loc_last_update_date;
3831: IF l_po_loc_association_csr%FOUND THEN
3832: CLOSE l_po_loc_association_csr;
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;

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

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

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

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

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

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

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

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

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

3981: x_return_status => x_return_status);
3982:
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;

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

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

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

4081: x_return_status => x_return_status);
4082:
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;

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

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

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

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

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

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

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

4247: x_return_status => x_return_status);
4248:
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;

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

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

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

4273: x_msg_data => x_msg_data);
4274:
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;

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

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

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

4336: ,X_MSG_DATA => X_MSG_DATA
4337: ,X_RETURN_STATUS => X_RETURN_STATUS);
4338: WHEN OTHERS THEN
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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4543: ,X_MSG_DATA => x_MSG_DATA
4544: ,X_RETURN_STATUS => x_RETURN_STATUS);
4545: WHEN OTHERS THEN
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

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

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

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

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

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

4670: x_return_status := FND_API.G_RET_STS_SUCCESS;
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',

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

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

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

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

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

4867: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4868: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
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;

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

4868: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
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

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

4894: OPEN get_country_location;
4895: FETCH get_country_location INTO csp_location_rec;
4896: CLOSE get_country_location;
4897: END IF;
4898: csp_location_rec.ADDRESS_LINE_1 := FND_MESSAGE.GET_STRING('CSP', 'CSP_ADDRESS_DESC');
4899:
4900: -- If address fields are not null, create a new inventory location. Otherwise, return error.
4901: IF p_country IS NOT NULL THEN
4902:

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

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

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

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

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

5057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5058: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
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;

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

5058: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
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;

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

5109: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5110: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
5111: 'In Others block... sqlerrm = ' || sqlerrm);
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

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

5110: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
5111: 'In Others block... sqlerrm = ' || sqlerrm);
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

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

5111: 'In Others block... sqlerrm = ' || sqlerrm);
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);

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

5182: end if;
5183:
5184: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
5185: THEN
5186: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');
5187: fnd_message.set_token (
5188: 'P_PROCEDURE',
5189: i.hook_package || '.' || i.hook_api,false
5190: );

Line 5187: fnd_message.set_token (

5183:
5184: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
5185: THEN
5186: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');
5187: fnd_message.set_token (
5188: 'P_PROCEDURE',
5189: i.hook_package || '.' || i.hook_api,false
5190: );
5191: fnd_msg_pub.add;

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

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

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

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

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

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

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

5488: ,X_MSG_DATA => X_MSG_DATA
5489: ,X_RETURN_STATUS => X_RETURN_STATUS);
5490: WHEN OTHERS THEN
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

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

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

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

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

Line 5891: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');

5887: po_moac_utils_pvt.set_org_context(l_current_org_id);
5888:
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

Line 5892: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);

5888:
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);

Line 5926: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');

5922: po_moac_utils_pvt.set_org_context(l_current_org_id);
5923:
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

Line 5927: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);

5923:
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);

Line 5961: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');

5957: po_moac_utils_pvt.set_org_context(l_current_org_id);
5958:
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

Line 5962: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);

5958:
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);

Line 6018: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');

6014: po_moac_utils_pvt.set_org_context(l_current_org_id);
6015:
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

Line 6019: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);

6015:
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);

Line 6053: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');

6049: po_moac_utils_pvt.set_org_context(l_current_org_id);
6050:
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

Line 6054: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);

6050:
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);

Line 6084: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');

6080: po_moac_utils_pvt.set_org_context(l_current_org_id);
6081:
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

Line 6085: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);

6081:
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);

Line 6121: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');

6117: po_moac_utils_pvt.set_org_context(l_current_org_id);
6118:
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

Line 6122: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);

6118:
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);

Line 6171: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');

6167: po_moac_utils_pvt.set_org_context(l_current_org_id);
6168:
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

Line 6172: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);

6168:
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);

Line 6223: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');

6219: end if;
6220:
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

Line 6224: FND_MESSAGE.SET_TOKEN('CSP_MSG', l_msg, FALSE);

6220:
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);