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_PC_FORM_PICKLINES dependencies on CSP_PICKLIST_LINES

Line 4: -- Purpose: wrapper for csp picklist lines private procedure which calls picklist lines table handlers

1: Package Body CSP_PC_FORM_PICKLINES AS
2: /* $Header: cspgtplb.pls 115.11 2002/11/26 06:45:56 hhaugeru ship $ */
3: -- Start of Commetns --
4: -- Purpose: wrapper for csp picklist lines private procedure which calls picklist lines table handlers
5: --
6: -- MODIFICATION HISTORY
7: -- Person Date Comments
8: -- --------- ------ ------------------------------------------

Line 78: l_picklist_line_rec CSP_PICKLIST_LINES_PVT.picklist_line_Rec_Type;

74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2)
77: IS
78: l_picklist_line_rec CSP_PICKLIST_LINES_PVT.picklist_line_Rec_Type;
79: l_api_version_number CONSTANT NUMBER := 1.0;
80: l_api_name CONSTANT VARCHAR2(20) := 'Validate_And_Write';
81: l_msg_data VARCHAR2(300);
82: l_check_existence NUMBER := 0;

Line 101: From csp_picklist_lines

97: l_last_update_login NUMBER := p_last_update_login;
98: l_last_updated_by NUMBER := p_last_updated_by;
99: Cursor l_Get_Creation_Date_Csr Is
100: Select creation_date
101: From csp_picklist_lines
102: Where picklist_line_id = px_PICKLIST_LINE_ID;
103:
104: BEGIN
105: SAVEPOINT Validate_And_Write_PUB;

Line 134: FROM CSP_PICKLIST_LINES

130: IF px_picklist_line_id IS NOT NULL THEN
131: -- valdiate whether an identical picklist_line_id already exists.
132: BEGIN
133: SELECt picklist_line_id into l_check_existence
134: FROM CSP_PICKLIST_LINES
135: WHERE picklist_line_id = px_picklist_line_id;
136:
137: fnd_message.set_name ('CSP', 'CSP_DUPLICATE_RECORD');
138: fnd_msg_pub.add;

Line 333: from csp_picklist_lines

329: RAISE EXCP_USER_DEFINED;
330: ELSE
331: BEGIN
332: select picklist_line_id into l_check_existence
333: from csp_picklist_lines
334: where picklist_line_id = px_picklist_line_id;
335: EXCEPTION
336: WHEN NO_DATA_FOUND THEN
337: fnd_message.set_name ('CSP', 'CSP_INVALID_PICKLIST');

Line 345: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);

341: WHEN OTHERS THEN
342: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
343: fnd_message.set_token('ERR_FIELD', 'px_picklist_line_id', FALSE);
344: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
345: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);
346: FND_MSG_PUB.ADD;
347: RAISE EXCP_USER_DEFINED;
348: END;
349: END IF;

Line 357: -- csp_picklist_lines table. Instead, we need to make sure that it exists in the csp_picklist_headers

353: --validate the pick list header id.
354: BEGIN
355: -- for bug 1238607.
356: -- Since we are updating the picklist_header_id, we do not need to check whether it exists in the
357: -- csp_picklist_lines table. Instead, we need to make sure that it exists in the csp_picklist_headers
358: -- table.
359: select picklist_header_id into l_check_existence
360: from csp_picklist_headers
361: where picklist_header_id = p_picklist_header_id;

Line 378: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);

374: WHEN OTHERS THEN
375: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
376: fnd_message.set_token('ERR_FIELD', 'px_picklist_line_id', FALSE);
377: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
378: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);
379: FND_MSG_PUB.ADD;
380: RAISE EXCP_USER_DEFINED;
381: END;
382:

Line 388: from csp_picklist_lines

384: -- find the organization_id based on the p_pick_line_id
385: select organization_id into l_organization_id
386: from csp_picklist_headers
387: where picklist_header_id = (select picklist_header_id
388: from csp_picklist_lines
389: where picklist_line_id = px_picklist_line_id);
390: END IF;
391:
392: --validating inventory_item_id

Line 493: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);

489: Close l_Get_Creation_Date_Csr;
490: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
491: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
492: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
493: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);
494: FND_MSG_PUB.ADD;
495: RAISE EXCP_USER_DEFINED;
496: End if;
497: Close l_Get_Creation_Date_Csr;

Line 513: from csp_picklist_lines

509: RAISE EXCP_USER_DEFINED;
510: ELSE
511: BEGIN
512: select picklist_line_id into l_check_existence
513: from csp_picklist_lines
514: where picklist_line_id = px_picklist_line_id;
515: EXCEPTION
516: WHEN NO_DATA_FOUND THEN
517: fnd_message.set_name ('CSP', 'CSP_INVALID_PICKLIST');

Line 525: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);

521: WHEN OTHERS THEN
522: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
523: fnd_message.set_token('ERR_FIELD', 'px_picklist_line_id', FALSE);
524: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
525: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);
526: FND_MSG_PUB.ADD;
527: RAISE EXCP_USER_DEFINED;
528: END;
529: END IF;

Line 567: csp_picklist_lines_pvt.Create_picklist_lines(

563: l_picklist_line_rec.ATTRIBUTE15 := p_ATTRIBUTE15;
564:
565:
566: IF p_action_code = 0 THEN
567: csp_picklist_lines_pvt.Create_picklist_lines(
568: P_Api_Version_Number => p_api_version_number,
569: P_Init_Msg_List => P_Init_Msg_List,
570: P_Commit => P_Commit,
571: p_validation_level => l_validation_level,

Line 580: csp_picklist_lines_pvt.Update_picklist_lines(

576: X_Msg_Data => x_msg_data
577: );
578:
579: ELSIF p_action_code = 1 THEN
580: csp_picklist_lines_pvt.Update_picklist_lines(
581: P_Api_Version_Number => p_api_version_number,
582: P_Init_Msg_List => P_Init_Msg_List,
583: P_Commit => P_Commit,
584: p_validation_level => l_validation_level,

Line 593: csp_picklist_lines_pvt.Delete_picklist_lines(

589: X_Msg_Data => x_msg_data
590: );
591:
592: ELSIF p_action_code = 2 THEN
593: csp_picklist_lines_pvt.Delete_picklist_lines(
594: P_Api_Version_Number => p_api_version_number,
595: P_Init_Msg_List => P_Init_Msg_List,
596: p_Commit => P_Commit,
597: p_validation_level => l_validation_level,