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_API

Line 258: x_return_status := FND_API.G_RET_STS_SUCCESS;

254: BEGIN
255: SAVEPOINT do_create_ship_to_location_PUB;
256:
257: -- Initialize
258: x_return_status := FND_API.G_RET_STS_SUCCESS;
259: select userenv('LANG') into l_language from dual;
260:
261: -- Assign location code
262: select csp_location_id_s1.NEXTVAL into l_location_code from dual;

Line 340: x_return_status := FND_API.G_RET_STS_ERROR;

336: -- Exception Block
337: EXCEPTION
338: WHEN EXCP_USER_DEFINED THEN
339: Rollback to do_create_ship_to_location_PUB;
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

Line 349: WHEN FND_API.G_EXC_ERROR THEN

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

Line 358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 376: x_return_status := FND_API.G_RET_STS_ERROR;

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:
378: END do_create_ship_to_location;
379:
380:

Line 448: x_return_status := FND_API.G_RET_STS_SUCCESS;

444: BEGIN
445: SAVEPOINT do_update_ship_to_location_PUB;
446:
447: -- initialize
448: x_return_status := FND_API.G_RET_STS_SUCCESS;
449: select userenv('LANG') into l_language from dual;
450:
451: /* OPEN l_inv_location_csr;
452: FETCH l_inv_location_csr INTO

Line 596: x_return_status := FND_API.G_RET_STS_ERROR;

592: -- Exception Block
593: EXCEPTION
594: WHEN EXCP_USER_DEFINED THEN
595: Rollback to do_update_ship_to_location_PUB;
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

Line 605: WHEN FND_API.G_EXC_ERROR THEN

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

Line 614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 632: x_return_status := FND_API.G_RET_STS_ERROR;

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:
634: END do_update_ship_to_location;
635:
636:

Line 812: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

808: x_msg_count => x_msg_count,
809: x_msg_data => x_msg_data,
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;*/

Line 933: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

929: x_msg_count => x_msg_count,
930: x_msg_data => x_msg_data,
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;*/

Line 945: x_return_status := FND_API.G_RET_STS_ERROR;

941: -- Exception Block
942: EXCEPTION
943: WHEN EXCP_USER_DEFINED THEN
944: Rollback to do_create_site_use_PUB;
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

Line 954: WHEN FND_API.G_EXC_ERROR THEN

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

Line 963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 981: x_return_status := FND_API.G_RET_STS_ERROR;

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:
983: END do_create_site_use;
984:
985:

Line 1602: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1598: x_msg_count => x_msg_count,
1599: x_msg_data => x_msg_data,
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;*/

Line 1842: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1838: x_msg_count => x_msg_count,
1839: x_msg_data => x_msg_data,
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;*/

Line 2079: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2075: x_msg_count => x_msg_count,
2076: x_msg_data => x_msg_data,
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;*/

Line 2096: x_return_status := FND_API.G_RET_STS_ERROR;

2092: -- Exception Block
2093: EXCEPTION
2094: WHEN EXCP_USER_DEFINED THEN
2095: Rollback to do_update_site_use_PUB;
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

Line 2105: WHEN FND_API.G_EXC_ERROR THEN

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

Line 2114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2132: x_return_status := FND_API.G_RET_STS_ERROR;

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:
2134: END do_update_site_use;
2135: ------------------------------------------------------------------------------------------
2136: -- Procedure Name : ship_to_address_handler

Line 2605: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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,
2608: G_PKG_NAME) THEN
2609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2605: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2606: p_api_version_number,
2607: l_api_name,
2608: G_PKG_NAME) THEN
2609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2610: END IF;
2611:
2612: x_return_status := FND_API.G_RET_STS_SUCCESS;
2613: select userenv('LANG') into s_language from dual;

Line 2612: x_return_status := FND_API.G_RET_STS_SUCCESS;

2608: G_PKG_NAME) THEN
2609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2610: END IF;
2611:
2612: x_return_status := FND_API.G_RET_STS_SUCCESS;
2613: select userenv('LANG') into s_language from dual;
2614: csp_ship_to_address_pvt.g_rs_cust_relation_id := null;
2615: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','SHIP_TO_ADDRESS_HANDLER','B',x_return_status);
2616:

Line 3309: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3305: ,x_msg_count => x_msg_count
3306: ,x_msg_data => x_msg_data);
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;*/

Line 3530: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3526: ,x_msg_count => x_msg_count
3527: ,x_msg_data => x_msg_data);
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;*/

Line 3693: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3689: x_return_status => x_return_status,
3690: x_msg_count => x_msg_count,
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;*/

Line 3717: IF p_commit = FND_API.G_TRUE THEN

3713: ELSIF l_process_type = 'UPDATE' THEN
3714: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','UPDATE_LOCATION','A',x_return_status);
3715: END IF;
3716: -- If no error occurs, commit.
3717: IF p_commit = FND_API.G_TRUE THEN
3718: COMMIT;
3719: END IF;
3720:
3721: fnd_msg_pub.count_and_get

Line 3729: x_return_status := FND_API.G_RET_STS_ERROR;

3725: -- Exception Block --
3726: EXCEPTION
3727: WHEN EXCP_USER_DEFINED THEN
3728: Rollback to ship_to_address_handler_PUB;
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

Line 3738: WHEN FND_API.G_EXC_ERROR THEN

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

Line 3747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 3765: x_return_status := FND_API.G_RET_STS_ERROR;

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:
3767: END ship_to_address_handler;
3768:
3769:

Line 3845: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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,
3848: G_PKG_NAME) THEN
3849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3845: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3846: p_api_version_number,
3847: l_api_name,
3848: G_PKG_NAME) THEN
3849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3850: END IF;
3851:
3852: x_return_status := FND_API.G_RET_STS_SUCCESS;
3853:

Line 3852: x_return_status := FND_API.G_RET_STS_SUCCESS;

3848: G_PKG_NAME) THEN
3849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3850: END IF;
3851:
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');

Line 3941: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3945: WHEN FND_API.G_EXC_ERROR 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(
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

Line 3954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 3972: x_return_status := FND_API.G_RET_STS_ERROR;

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:
3974: END site_to_invloc_linkage; */
3975: PROCEDURE site_to_invloc_linkage
3976: (p_customer_id IN NUMBER

Line 4064: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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,
4067: G_PKG_NAME) THEN
4068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4064: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4065: p_api_version_number,
4066: l_api_name,
4067: G_PKG_NAME) THEN
4068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4069: END IF;
4070:
4071: x_return_status := FND_API.G_RET_STS_SUCCESS;
4072:

Line 4071: x_return_status := FND_API.G_RET_STS_SUCCESS;

4067: G_PKG_NAME) THEN
4068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4069: END IF;
4070:
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');

Line 4256: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 4260: WHEN FND_API.G_EXC_ERROR 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(
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

Line 4269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4287: x_return_status := FND_API.G_RET_STS_ERROR;

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:
4289: END site_to_invloc_linkage;
4290: PROCEDURE call_internal_hook (
4291: p_package_name IN VARCHAR2,

Line 4311: x_return_status := fnd_api.g_ret_sts_success;

4307: v_cursorid INTEGER;
4308: v_blockstr VARCHAR2(2000);
4309: v_dummy INTEGER;
4310: BEGIN
4311: x_return_status := fnd_api.g_ret_sts_success;
4312:
4313: FOR i IN c1
4314: LOOP
4315: v_cursorid := DBMS_SQL.open_cursor;

Line 4324: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

4320: v_dummy := DBMS_SQL.execute (v_cursorid);
4321: DBMS_SQL.variable_value (v_cursorid, ':1', x_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',

Line 4332: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 4333: RAISE fnd_api.g_exc_unexpected_error;

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

Line 4334: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
4336: END IF;
4337:
4338: IF x_return_status IS NULL

Line 4335: RAISE fnd_api.g_exc_unexpected_error;

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;
4336: END IF;
4337:
4338: IF x_return_status IS NULL
4339: THEN

Line 4342: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
4346: EXCEPTION

Line 4343: RAISE fnd_api.g_exc_unexpected_error;

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;
4346: EXCEPTION
4347: WHEN fnd_api.g_exc_unexpected_error

Line 4347: WHEN fnd_api.g_exc_unexpected_error

4343: RAISE fnd_api.g_exc_unexpected_error;
4344: END IF;
4345: END LOOP;
4346: EXCEPTION
4347: WHEN fnd_api.g_exc_unexpected_error
4348: THEN
4349: x_return_status := fnd_api.g_ret_sts_unexp_error;
4350: WHEN OTHERS
4351: THEN

Line 4349: x_return_status := fnd_api.g_ret_sts_unexp_error;

4345: END LOOP;
4346: EXCEPTION
4347: WHEN fnd_api.g_exc_unexpected_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);

Line 4355: x_return_status := fnd_api.g_ret_sts_unexp_error;

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
4359: ( p_api_version IN NUMBER

Line 4360: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

4356: END;
4357:
4358: PROCEDURE cust_inv_loc_link
4359: ( p_api_version IN NUMBER
4360: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
4361: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
4362: ,px_location_id IN OUT NOCOPY NUMBER
4363: ,p_party_site_id IN NUMBER
4364: ,p_cust_account_id IN NUMBER

Line 4361: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

4357:
4358: PROCEDURE cust_inv_loc_link
4359: ( p_api_version IN NUMBER
4360: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
4361: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
4362: ,px_location_id IN OUT NOCOPY NUMBER
4363: ,p_party_site_id IN NUMBER
4364: ,p_cust_account_id IN NUMBER
4365: ,p_customer_id IN NUMBER

Line 4558: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4554: ,X_MSG_COUNT => l_msg_count
4555: ,X_MSG_DATA => l_msg_data
4556: );
4557:
4558: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4559: RAISE FND_API.G_EXC_ERROR;
4560: END IF;
4561: px_location_id := l_location_id;
4562: ELSE

Line 4559: RAISE FND_API.G_EXC_ERROR;

4555: ,X_MSG_DATA => l_msg_data
4556: );
4557:
4558: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4559: RAISE FND_API.G_EXC_ERROR;
4560: END IF;
4561: px_location_id := l_location_id;
4562: ELSE
4563: px_location_id := l_inv_location_id;

Line 4571: WHEN FND_API.G_EXC_ERROR THEN

4567: null;
4568: END IF;
4569: END If;
4570: EXCEPTION
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

Line 4580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4598: x_return_status := FND_API.G_RET_STS_ERROR;

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:
4600: END;
4601:
4602: END CSP_SHIP_TO_ADDRESS_PVT;