DBA Data[Home] [Help]

APPS.QA_SS_CORE dependencies on QA_SS_CORE

Line 1: package body qa_ss_core as

1: package body qa_ss_core as
2: /* $Header: qltsscob.plb 115.28 2002/11/27 19:31:45 jezheng ship $ */
3:
4: /*
5:

Line 64: htp.p('Exception in private function qa_ss_core.get_char_prompt');

60: WHEN OTHERS THEN
61: IF c%ISOPEN THEN
62: CLOSE c;
63: END IF;
64: htp.p('Exception in private function qa_ss_core.get_char_prompt');
65: htp.p(SQLERRM);
66:
67: END get_char_prompt;
68: -----------------------------------------------------------------

Line 120: htp.p('Exception in private function qa_ss_core.Is_Job_Valid');

116: END IF;
117: IF wdj_open_val_cur%ISOPEN THEN
118: CLOSE wdj_open_val_cur;
119: END IF;
120: htp.p('Exception in private function qa_ss_core.Is_Job_Valid');
121: htp.p(SQLERRM);
122:
123: END Is_Job_Valid;
124:

Line 431: htp.p('
');

427:
428: htp.p('');
429:
430: -- BELOW WORKFLOWDOC added for Bug 998381
431: htp.p('');
432: htp.formHidden('x_buyer_id', po_agent_id);
433: htp.formHidden('x_source_id', x_source_id);
434: htp.formHidden('x_plan_id', hid_planid);
435: htp.formHidden('x_item_id', x_item_id);

Line 852: l_prompt := qa_ss_core.get_char_prompt(charid_tab(c));

848: flg1 := qa_results_interface_pkg.add_element_value(hid_planid, charid_tab(c),
849: values_tab(c), script, tailscript);
850:
851: if (flg1 = 2) then
852: l_prompt := qa_ss_core.get_char_prompt(charid_tab(c));
853: fnd_message.set_name('QA', 'QA_SS_INVALID_NUM');
854: fnd_message.set_token('ROWNUMBER', r);
855: fnd_message.set_token('COLNUMBER', c);
856: fnd_message.set_token('ELEMENT', l_prompt);

Line 862: l_prompt := qa_ss_core.get_char_prompt(charid_tab(c));

858: htp.p(''||fnd_message.get||'');
859: htp.nl;
860: No_problem := FALSE; -- this means, there is some error
861: elsif (flg1 = 3) then
862: l_prompt := qa_ss_core.get_char_prompt(charid_tab(c));
863: fnd_message.set_name('QA', 'QA_SS_INVALID_DATE');
864: fnd_message.set_token('ROWNUMBER', r);
865: fnd_message.set_token('COLNUMBER', c);
866: fnd_message.set_token('ELEMENT', l_prompt);

Line 876: l_prompt := qa_ss_core.get_char_prompt(charid_tab(c));

872: -- Adding if statement, Sep 13, 1999 -- talked to mmpatel
873: -- accept null context elems even if they r mandatory BUG 998445
874: if (NOT CxE(charid_tab(c), txn_num)) -- if not a ctx elem, then process
875: then
876: l_prompt := qa_ss_core.get_char_prompt(charid_tab(c));
877: fnd_message.set_name('QA', 'QA_SS_MAND_VALUE');
878: fnd_message.set_token('ROWNUMBER', r);
879: fnd_message.set_token('COLNUMBER', c);
880: fnd_message.set_token('ELEMENT', l_prompt);

Line 887: l_prompt := qa_ss_core.get_char_prompt(charid_tab(c));

883: htp.nl;
884: No_problem := FALSE; -- this means, there is some error
885: end if;
886: elsif (flg1 = 1) then
887: l_prompt := qa_ss_core.get_char_prompt(charid_tab(c));
888: fnd_message.set_name('QA', 'QA_SS_GENERIC_INVALID');
889: fnd_message.set_token('ROWNUMBER', r);
890: fnd_message.set_token('COLNUMBER', c);
891: fnd_message.set_token('ELEMENT', l_prompt);

Line 1102: htp.p('');

1098: htp.formHidden('x_wip_line_id', l_wip_line_id);
1099: htp.formHidden('x_po_shipment_id', l_po_shipment_id);
1100: htp.p('');
1101:
1102: htp.p('

');
1103: htp.formHidden('x_buyer_id', l_po_agent_id);
1104: htp.formHidden('x_source_id', l_user_id);
1105: htp.formHidden('x_plan_id', plan_id_i);
1106: htp.formHidden('x_item_id', l_Item_Id);

Line 1110: htp.p('');

1106: htp.formHidden('x_item_id', l_Item_Id);
1107: htp.formHidden('x_po_header_id', l_po_header_id);
1108: htp.p('

');
1109:
1110: htp.p('
');
1111: -- htp.formHidden('No_Dependency','No_Dependency'); --This is no longer needed
1112:
1113: htp.tableOpen(cborder=>'BORDER=2',calign=>'CENTER', cattributes=>'CELLPADDING=2 cellspacing=1');
1114:

Line 1453: xyz := 'qa_ss_core.draw_table?plan_id_i=' || plan_id_i

1449: OPEN plan_name_cur;
1450: FETCH plan_name_cur INTO l_plan_name;
1451: CLOSE plan_name_cur;
1452:
1453: xyz := 'qa_ss_core.draw_table?plan_id_i=' || plan_id_i
1454: || '&' || 'txn_num=' || Txn_Num
1455: || '&' || 'orgz_id=' || orgz_id
1456: || '&' || 'pk1=' || pk1
1457: || '&' || 'pk2=' || pk2

Line 1567: htp.p('

1563: marginwidth=0
1564: marginheight=0
1565: scrolling=no>');
1566: htp.p('');
1567: htp.p(' 1568: name=buttonsFrame
1569: marginwidth=0
1570: marginheight=0
1571: scrolling=no>');

Line 1630: qa_ss_core.draw_html_button('javascript:parent.eqr_submit()', msg);

1626: htp.p('');
1627: htp.p('');
1628: htp.p('');
1646:
1647: fnd_message.clear;
1648:

Line 1663: qa_ss_core.draw_html_button('javascript:parent.notify_buyer('''||msg||''')',

1659: P_JavaScriptFlag => FALSE);
1660: */
1661: IF ( (l_profile_val = 1) OR (l_profile_val IS NULL) ) THEN
1662: htp.p('

');
1666: END IF; -- end check for l_profile_val
1667:

Line 1919: srow_st := 'qa_ss_core.VQR?plan_id_i='|| plan_id_i

1915: */
1916:
1917: htp.tableClose;
1918:
1919: srow_st := 'qa_ss_core.VQR?plan_id_i='|| plan_id_i
1920: || '&' || 'start_row=' || to_char(start_row-l_query_size)
1921: || '&' || 'end_row=' || to_char(start_row-1)
1922: || '&' || 'ss_where_clause=' || ss_w_c;
1923:

Line 1925: erow_st := 'qa_ss_core.VQR?plan_id_i='|| plan_id_i

1921: || '&' || 'end_row=' || to_char(start_row-1)
1922: || '&' || 'ss_where_clause=' || ss_w_c;
1923:
1924:
1925: erow_st := 'qa_ss_core.VQR?plan_id_i='|| plan_id_i
1926: || '&' || 'start_row=' || to_char(end_row+1)
1927: || '&' || 'end_row=' || to_char(end_row+l_query_size)
1928: || '&' || 'ss_where_clause=' || ss_w_c;
1929:

Line 3356: -- ORA-06512: at "APPS.QA_SS_CORE", line 3327

3352: htp.p(''||SQLERRM||'');
3353: -- anagarwa Thu Nov 8 11:24:34 PST 2001
3354: -- Following return added to handle following problem (Bug #2101177) :
3355: -- ORA-06503: PL/SQL: Function returned without value
3356: -- ORA-06512: at "APPS.QA_SS_CORE", line 3327
3357: -- ORA-06512: at "APPS.QA_SS_OSP", line 48
3358: -- ORA-06512: at line 1
3359: RETURN FALSE;
3360: END any_applicable_plans;

Line 3557: -- ORA-06512: at "APPS.QA_SS_CORE", line 3327

3553: htp.p(''||SQLERRM||'');
3554: -- anagarwa Thu Nov 8 11:24:34 PST 2001
3555: -- Following return added to handle following problem (Bug #2101177) :
3556: -- ORA-06503: PL/SQL: Function returned without value
3557: -- ORA-06512: at "APPS.QA_SS_CORE", line 3327
3558: -- ORA-06512: at "APPS.QA_SS_OSP", line 48
3559: -- ORA-06512: at line 1
3560: RETURN FALSE;
3561: END Evaluate_Triggers;

Line 3669: window.location = "qa_ss_core.VQR?plan_id_i="+plan_id;

3665: /* -- Javascript COMMENTED OUT
3666: htp.p('

');
1629:
1630: qa_ss_core.draw_html_button('javascript:parent.eqr_submit()', msg);
1631:
1632: fnd_message.set_name('QA', 'QA_SS_CLEAR_FORM');
1633: msg := fnd_message.get;
1634: msg := substr(msg, 1, 20);

Line 1644: qa_ss_core.draw_html_button('javascript:parent.clr_form()', msg);

1640: P_LanguageCode => l_language_code,
1641: P_JavaScriptFlag => FALSE);
1642: */
1643: htp.p('

');
1644: qa_ss_core.draw_html_button('javascript:parent.clr_form()', msg);
1645: htp.p('		 ');
1663: qa_ss_core.draw_html_button('javascript:parent.notify_buyer('''||msg||''')',
1664: substr(fnd_message.get_string('QA','QA_SS_NOTIFY'),1,23) );
1665: htp.p('