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_PL_SHIP_UTIL dependencies on CSP_PACKLIST_HEADERS

Line 165: From CSP_PACKLIST_HEADERS

161: ATTRIBUTE12 ,
162: ATTRIBUTE13 ,
163: ATTRIBUTE14 ,
164: ATTRIBUTE15
165: From CSP_PACKLIST_HEADERS
166: WHERE organization_id = p_organization_id
167: AND packlist_header_id = p_packlist_header_id;
168:
169: l_packlist_headers_rec CSP_packlist_headers_PVT.PLH_Rec_Type;

Line 169: l_packlist_headers_rec CSP_packlist_headers_PVT.PLH_Rec_Type;

165: From CSP_PACKLIST_HEADERS
166: WHERE organization_id = p_organization_id
167: AND packlist_header_id = p_packlist_header_id;
168:
169: l_packlist_headers_rec CSP_packlist_headers_PVT.PLH_Rec_Type;
170: l_packlist_line_rec CSP_packlist_lines_PVT.PLL_Rec_Type;
171: l_transaction_header_id NUMBER := null;
172: l_temp_id NUMBER;
173: l_move_order_line_id NUMBER;

Line 247: from csp_packlist_headers

243: ELSE
244: IF p_validation_level = fnd_api.g_valid_level_full THEN
245: BEGIN
246: select packlist_header_id into l_check_existence
247: from csp_packlist_headers
248: where organization_id = p_organization_id
249: and packlist_header_id = p_packlist_header_id;
250: EXCEPTION
251: WHEN NO_DATA_FOUND THEN

Line 260: fnd_message.set_token('TABLE', 'csp_packlist_headers', TRUE);

256: WHEN OTHERS THEN
257: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
258: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_id', TRUE);
259: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
260: fnd_message.set_token('TABLE', 'csp_packlist_headers', TRUE);
261: FND_MSG_PUB.ADD;
262: RAISE EXCP_USER_DEFINED;
263: END;
264: END IF;

Line 296: -- call the CSP_Packlist_Headers_PVT.Update_packlist_headers to updat the packlist_status.

292: x_return_status => l_return_status,
293: x_msg_count => l_msg_count,
294: x_msg_data => l_msg_data );*/
295:
296: -- call the CSP_Packlist_Headers_PVT.Update_packlist_headers to updat the packlist_status.
297: CSP_Packlist_Headers_PVT.Update_packlist_headers(
298: P_Api_Version_Number => l_api_version_number,
299: P_Init_Msg_List => p_init_msg_list,
300: P_Commit => FND_API.G_FALSE,

Line 297: CSP_Packlist_Headers_PVT.Update_packlist_headers(

293: x_msg_count => l_msg_count,
294: x_msg_data => l_msg_data );*/
295:
296: -- call the CSP_Packlist_Headers_PVT.Update_packlist_headers to updat the packlist_status.
297: CSP_Packlist_Headers_PVT.Update_packlist_headers(
298: P_Api_Version_Number => l_api_version_number,
299: P_Init_Msg_List => p_init_msg_list,
300: P_Commit => FND_API.G_FALSE,
301: p_validation_level => l_validation_level,

Line 897: From CSP_PACKLIST_HEADERS

893: ATTRIBUTE12 ,
894: ATTRIBUTE13 ,
895: ATTRIBUTE14 ,
896: ATTRIBUTE15
897: From CSP_PACKLIST_HEADERS
898: WHERE organization_id = p_organization_id
899: AND packlist_header_id = p_packlist_header_id;
900:
901: l_packlist_headers_rec CSP_packlist_headers_PVT.PLH_Rec_Type;

Line 901: l_packlist_headers_rec CSP_packlist_headers_PVT.PLH_Rec_Type;

897: From CSP_PACKLIST_HEADERS
898: WHERE organization_id = p_organization_id
899: AND packlist_header_id = p_packlist_header_id;
900:
901: l_packlist_headers_rec CSP_packlist_headers_PVT.PLH_Rec_Type;
902: l_api_version_number CONSTANT NUMBER := 1.0;
903: l_api_name CONSTANT VARCHAR2(50) := 'Update_Packlist_Sts_Qty';
904: l_msg_count NUMBER;
905: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 968: from csp_packlist_headers

964: ELSE
965: -- IF p_validation_level = fnd_api.g_valid_level_full THEN
966: BEGIN
967: select packlist_header_id into l_check_existence
968: from csp_packlist_headers
969: where organization_id = p_organization_id
970: and packlist_header_id = p_packlist_header_id;
971: EXCEPTION
972: WHEN NO_DATA_FOUND THEN

Line 981: fnd_message.set_token('TABLE', 'csp_packlist_headers', TRUE);

977: WHEN OTHERS THEN
978: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
979: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_id', TRUE);
980: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
981: fnd_message.set_token('TABLE', 'csp_packlist_headers', TRUE);
982: FND_MSG_PUB.ADD;
983: RAISE EXCP_USER_DEFINED;
984: END;
985: --END IF;

Line 1009: -- call the CSP_Packlist_Headers_PVT.Update_packlist_headers to updat the packlist_status.

1005: END IF;
1006:
1007: l_packlist_headers_rec.last_update_date := sysdate;
1008:
1009: -- call the CSP_Packlist_Headers_PVT.Update_packlist_headers to updat the packlist_status.
1010: CSP_Packlist_Headers_PVT.Update_packlist_headers(
1011: P_Api_Version_Number => l_api_version_number,
1012: P_Init_Msg_List => p_init_msg_list,
1013: P_Commit => FND_API.G_FALSE,

Line 1010: CSP_Packlist_Headers_PVT.Update_packlist_headers(

1006:
1007: l_packlist_headers_rec.last_update_date := sysdate;
1008:
1009: -- call the CSP_Packlist_Headers_PVT.Update_packlist_headers to updat the packlist_status.
1010: CSP_Packlist_Headers_PVT.Update_packlist_headers(
1011: P_Api_Version_Number => l_api_version_number,
1012: P_Init_Msg_List => p_init_msg_list,
1013: P_Commit => FND_API.G_FALSE,
1014: p_validation_level => l_validation_level,