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.PON_AUCTION_INTERFACE_PKG dependencies on STANDARD

Line 29: P_CONTRACT_TYPE IN 'STANDARD' or 'BLANKET'

25: PROCEDURE : Create_Draft_Negotiation PUBLIC
26: PARAMETERS:
27: P_DOCUMENT_TITLE IN Title of negotiation
28: P_DOCUMENT_TYPE IN 'BUYER_AUCTION' or 'REQUEST_FOR_QUOTE'
29: P_CONTRACT_TYPE IN 'STANDARD' or 'BLANKET'
30: P_ORIGINATION_CODE IN 'REQUISITION' or caller product name
31: P_ORG_ID IN Organization id of creator
32: P_BUYER_ID IN FND_USER_ID of creator
33: P_NEG_STYLE_ID IN negotiation style id

Line 121: l_standard_form pon_auction_headers_all.standard_form%TYPE :=NULL;

117: l_doc_exist VARCHAR2(1);
118: l_err_msg VARCHAR2(2000);
119: l_sol_type VARCHAR2(3);
120: clm_doc_number VARCHAR2(100);
121: l_standard_form pon_auction_headers_all.standard_form%TYPE :=NULL;
122: l_document_format pon_auction_headers_all.document_format%TYPE:=NULL;
123: l_draft_locked pon_auction_headers_all.draft_locked%TYPE;
124: l_draft_locked_by pon_auction_headers_all.draft_locked_by%TYPE;
125: l_draft_locked_by_contact_id pon_auction_headers_all.draft_locked_by_contact_id%TYPE;

Line 138: IF (P_CONTRACT_TYPE NOT IN ('BLANKET', 'STANDARD')) THEN

134: P_ERROR_MESSAGE := 'Invalid Document Type ' || P_DOCUMENT_TYPE;
135: logme(l_log_module, p_error_code ||' - '||p_error_message);
136: RETURN;
137: END IF;
138: IF (P_CONTRACT_TYPE NOT IN ('BLANKET', 'STANDARD')) THEN
139: P_RESULT := error;
140: P_ERROR_CODE := 'CREATE_DRAFT:INVALID_CONTRACT_TYPE';
141: P_ERROR_MESSAGE := 'Invalid Contract Type ' || P_CONTRACT_TYPE;
142: logme(l_log_module, p_error_code ||' - '||p_error_message);

Line 295: IF (p_Contract_type <> 'STANDARD') THEN

291: P_ERROR_MESSAGE := 'Invalid Document Type For Complex Work Style ' || P_CONTRACT_TYPE;
292: logme(l_log_module, p_error_code ||' - '||p_error_message);
293: RETURN;
294: END IF;
295: IF (p_Contract_type <> 'STANDARD') THEN
296: P_RESULT := error;
297: P_ERROR_CODE := 'CREATE_DRAFT:INVALID_CONTRACT_TYPE';
298: P_ERROR_MESSAGE := 'Invalid Contract Type For Complex Work Style ' || P_CONTRACT_TYPE;
299: logme(l_log_module, p_error_code ||' - '||p_error_message);

Line 446: SELECT STANDARD_FORM,

442: l_sol_type := 'RFQ';
443: END IF;
444: --
445: BEGIN
446: SELECT STANDARD_FORM,
447: DOCUMENT_FORMAT
448: INTO l_standard_form,
449: l_document_format
450: FROM PO_PRINT_FORM_FORMATS

Line 448: INTO l_standard_form,

444: --
445: BEGIN
446: SELECT STANDARD_FORM,
447: DOCUMENT_FORMAT
448: INTO l_standard_form,
449: l_document_format
450: FROM PO_PRINT_FORM_FORMATS
451: WHERE FORM_SOURCE='PON'
452: AND DEFAULT_FLAG ='Y'

Line 457: l_standard_form :=NULL;

453: AND DOCUMENT_TYPE='PO_SOL_STD_FORM'
454: AND SYSDATE < NVL(INACTIVE_DATE,SYSDATE + 1);
455: EXCEPTION
456: WHEN Too_Many_Rows THEN
457: l_standard_form :=NULL;
458: l_document_format:=NULL;
459: WHEN No_Data_Found THEN
460: l_standard_form :=NULL;
461: l_document_format:=NULL;

Line 460: l_standard_form :=NULL;

456: WHEN Too_Many_Rows THEN
457: l_standard_form :=NULL;
458: l_document_format:=NULL;
459: WHEN No_Data_Found THEN
460: l_standard_form :=NULL;
461: l_document_format:=NULL;
462: END;
463: logme('pon.plsql.PON_auction_interface_pkg.Create_Draft_Negotiation',
464: 'Inserting into pon_auction_headers_all');

Line 547: STANDARD_FORM,

543: UDA_TEMPLATE_ID, -- uda_template_id
544: UDA_TEMPLATE_DATE,
545: SOLICITATION_TYPE,
546: REVISION,
547: STANDARD_FORM,
548: DOCUMENT_FORMAT,
549: FAIR_OPP_NOTICE_FLAG
550: )
551: VALUES

Line 631: l_standard_form,

627: l_uda_template_id, -- uda_template_id
628: l_uda_template_date,
629: l_sol_type,
630: 0,
631: l_standard_form,
632: l_document_format,
633: p_fair_opp_notice_flag
634: )
635: RETURNING auction_header_id

Line 706: P_CONTRACT_TYPE IN 'STANDARD' or 'BLANKET'

702: /*======================================================================
703: PROCEDURE : Add_Negotiation_Line
704: PARAMETERS:
705: P_DOCUMENT_NUMBER IN Document number to add line
706: P_CONTRACT_TYPE IN 'STANDARD' or 'BLANKET'
707: P_ORIGINATION_CODE IN 'REQUISITION' or caller product name
708: P_ORG_ID IN Organization id of creator
709: P_BUYER_ID IN FND_USER_ID of creator
710: P_GROUPING_TYPE IN 'DEFAULT' or 'NONE' grouping

Line 802: P_CONTRACT_TYPE IN 'STANDARD' or 'BLANKET'

798: /*======================================================================
799: PROCEDURE : Add_Negotiation_Line (OverLoaded for CLIN SLIN PROJECT)
800: PARAMETERS:
801: P_DOCUMENT_NUMBER IN Document number to add line
802: P_CONTRACT_TYPE IN 'STANDARD' or 'BLANKET'
803: P_ORIGINATION_CODE IN 'REQUISITION' or caller product name
804: P_ORG_ID IN Organization id of creator
805: P_BUYER_ID IN FND_USER_ID of creator
806: P_GROUPING_TYPE IN 'DEFAULT' or 'NONE' grouping

Line 978: /* IF (P_CONTRACT_TYPE NOT IN ('BLANKET', 'STANDARD')) THEN

974: P_ERROR_MESSAGE := 'Please provide a DOCUMENT_NUMBER';
975: logme(l_log_module, p_error_code ||' - '||p_error_message);
976: RETURN;
977: END IF;
978: /* IF (P_CONTRACT_TYPE NOT IN ('BLANKET', 'STANDARD')) THEN
979: P_RESULT := error;
980: P_ERROR_CODE := 'ADD_NEG_LINE:INVALID_CONTRACT_TYPE';
981: P_ERROR_MESSAGE := 'Invalid Contract Type ' || P_CONTRACT_TYPE;
982: logme(l_log_module, p_error_code ||' - '||p_error_message);

Line 1268: IF (V_CONTRACT_TYPE = 'STANDARD') THEN

1264:
1265: IF l_line_exist = 'Y' THEN
1266: logme(l_log_module, 'Line valid test ');
1267: l_line_valid := 'N';
1268: IF (V_CONTRACT_TYPE = 'STANDARD') THEN
1269: BEGIN
1270: SELECT 'Y'
1271: INTO l_line_valid
1272: FROM pon_auction_item_prices_all

Line 1347: IF (V_CONTRACT_TYPE = 'STANDARD') THEN

1343: logme('pon.plsql.pon_auction_interface_pkg.add_negotiation_line', 'p_line_number '||p_line_number);
1344:
1345: IF (P_LINE_NUMBER IS NULL OR P_LINE_NUMBER = 0) THEN
1346: logme(l_log_module, 'Grouping Line search select ');
1347: IF (V_CONTRACT_TYPE = 'STANDARD') THEN
1348: SELECT MAX(line_number)
1349: INTO P_LINE_NUMBER
1350: FROM pon_auction_item_prices_all
1351: WHERE auction_header_id = P_DOCUMENT_NUMBER