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 FND_MESSAGE

Line 167: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');

163: EXCEPTION
164: WHEN no_data_found THEN
165: P_RESULT := error;
166: P_ERROR_CODE := 'CREATE_DRAFT:MULTI_ORG_QUERY';
167: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
168: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
169: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');
170: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
171: fnd_message.retrieve(P_ERROR_MESSAGE);

Line 168: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

164: WHEN no_data_found THEN
165: P_RESULT := error;
166: P_ERROR_CODE := 'CREATE_DRAFT:MULTI_ORG_QUERY';
167: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
168: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
169: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');
170: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
171: fnd_message.retrieve(P_ERROR_MESSAGE);
172: logme(l_log_module, p_error_code ||' - '||p_error_message);

Line 169: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');

165: P_RESULT := error;
166: P_ERROR_CODE := 'CREATE_DRAFT:MULTI_ORG_QUERY';
167: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
168: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
169: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');
170: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
171: fnd_message.retrieve(P_ERROR_MESSAGE);
172: logme(l_log_module, p_error_code ||' - '||p_error_message);
173: RETURN;

Line 170: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');

166: P_ERROR_CODE := 'CREATE_DRAFT:MULTI_ORG_QUERY';
167: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
168: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
169: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');
170: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
171: fnd_message.retrieve(P_ERROR_MESSAGE);
172: logme(l_log_module, p_error_code ||' - '||p_error_message);
173: RETURN;
174: END;

Line 171: fnd_message.retrieve(P_ERROR_MESSAGE);

167: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
168: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
169: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');
170: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
171: fnd_message.retrieve(P_ERROR_MESSAGE);
172: logme(l_log_module, p_error_code ||' - '||p_error_message);
173: RETURN;
174: END;
175: IF (P_DOCUMENT_NUMBER IS NOT NULL) THEN

Line 189: --fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');

185: EXCEPTION
186: WHEN no_data_found THEN
187: P_RESULT := error;
188: P_ERROR_CODE := 'ADD_TO_DRAFT:DOC_QUERY';
189: --fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
190: --fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
191: --fnd_message.retrieve(P_ERROR_MESSAGE);
192: logme(l_log_module, p_error_code ||' - '||p_error_message);
193: RETURN;

Line 190: --fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

186: WHEN no_data_found THEN
187: P_RESULT := error;
188: P_ERROR_CODE := 'ADD_TO_DRAFT:DOC_QUERY';
189: --fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
190: --fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
191: --fnd_message.retrieve(P_ERROR_MESSAGE);
192: logme(l_log_module, p_error_code ||' - '||p_error_message);
193: RETURN;
194: END;

Line 191: --fnd_message.retrieve(P_ERROR_MESSAGE);

187: P_RESULT := error;
188: P_ERROR_CODE := 'ADD_TO_DRAFT:DOC_QUERY';
189: --fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
190: --fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
191: --fnd_message.retrieve(P_ERROR_MESSAGE);
192: logme(l_log_module, p_error_code ||' - '||p_error_message);
193: RETURN;
194: END;
195: logme(l_log_module, 'draft locked '|| l_draft_locked||' locked by '||

Line 696: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');

692: P_ERROR_MESSAGE := NULL;
693: logme('pon.plsql.pon_auction_interface_pkg.Create_Draft_Negotiation', 'Return from Create_Draft_Negotiation');
694: EXCEPTION
695: WHEN OTHERS THEN
696: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
697: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
698: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');
699: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
700: APP_EXCEPTION.RAISE_EXCEPTION;

Line 697: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

693: logme('pon.plsql.pon_auction_interface_pkg.Create_Draft_Negotiation', 'Return from Create_Draft_Negotiation');
694: EXCEPTION
695: WHEN OTHERS THEN
696: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
697: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
698: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');
699: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
700: APP_EXCEPTION.RAISE_EXCEPTION;
701: END;

Line 698: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');

694: EXCEPTION
695: WHEN OTHERS THEN
696: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
697: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
698: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');
699: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
700: APP_EXCEPTION.RAISE_EXCEPTION;
701: END;
702: /*======================================================================

Line 699: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');

695: WHEN OTHERS THEN
696: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
697: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
698: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');
699: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
700: APP_EXCEPTION.RAISE_EXCEPTION;
701: END;
702: /*======================================================================
703: PROCEDURE : Add_Negotiation_Line

Line 1094: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');

1090: EXCEPTION
1091: WHEN no_data_found THEN
1092: P_RESULT := error;
1093: P_ERROR_CODE := 'ADD_NEG_LINE:MULTI_ORG_QUERY';
1094: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1095: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1096: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');
1097: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
1098: fnd_message.retrieve(P_ERROR_MESSAGE);

Line 1095: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

1091: WHEN no_data_found THEN
1092: P_RESULT := error;
1093: P_ERROR_CODE := 'ADD_NEG_LINE:MULTI_ORG_QUERY';
1094: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1095: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1096: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');
1097: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
1098: fnd_message.retrieve(P_ERROR_MESSAGE);
1099: logme(l_log_module, p_error_code ||' - '||p_error_message);

Line 1096: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');

1092: P_RESULT := error;
1093: P_ERROR_CODE := 'ADD_NEG_LINE:MULTI_ORG_QUERY';
1094: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1095: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1096: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');
1097: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
1098: fnd_message.retrieve(P_ERROR_MESSAGE);
1099: logme(l_log_module, p_error_code ||' - '||p_error_message);
1100: RETURN;

Line 1097: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');

1093: P_ERROR_CODE := 'ADD_NEG_LINE:MULTI_ORG_QUERY';
1094: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1095: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1096: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');
1097: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
1098: fnd_message.retrieve(P_ERROR_MESSAGE);
1099: logme(l_log_module, p_error_code ||' - '||p_error_message);
1100: RETURN;
1101: END;

Line 1098: fnd_message.retrieve(P_ERROR_MESSAGE);

1094: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1095: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1096: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');
1097: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
1098: fnd_message.retrieve(P_ERROR_MESSAGE);
1099: logme(l_log_module, p_error_code ||' - '||p_error_message);
1100: RETURN;
1101: END;
1102: IF (P_ORG_ID IS NULL AND v_multi_org = 'Y') THEN

Line 1928: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');

1924: P_ERROR_CODE := NULL;
1925: P_ERROR_MESSAGE := NULL;
1926: EXCEPTION
1927: WHEN OTHERS THEN
1928: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1929: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1930: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');
1931: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
1932: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1929: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

1925: P_ERROR_MESSAGE := NULL;
1926: EXCEPTION
1927: WHEN OTHERS THEN
1928: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1929: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1930: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');
1931: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
1932: APP_EXCEPTION.RAISE_EXCEPTION;
1933: END;

Line 1930: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');

1926: EXCEPTION
1927: WHEN OTHERS THEN
1928: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1929: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1930: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');
1931: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
1932: APP_EXCEPTION.RAISE_EXCEPTION;
1933: END;
1934: /*============ADDED FOR UNIFIED CATALOG PROJECT=====================

Line 1931: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');

1927: WHEN OTHERS THEN
1928: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1929: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1930: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');
1931: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
1932: APP_EXCEPTION.RAISE_EXCEPTION;
1933: END;
1934: /*============ADDED FOR UNIFIED CATALOG PROJECT=====================
1935: PROCEDURE : Add_Catalog_Descriptors

Line 2209: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');

2205: EXCEPTION
2206: WHEN OTHERS THEN
2207: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;
2208: X_MSG_COUNT := 1;
2209: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2210: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2211: fnd_message.set_token('PROCEDURE','Add_Catalog_Descriptors');
2212: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
2213: fnd_message.retrieve(X_MSG_DATA);

Line 2210: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

2206: WHEN OTHERS THEN
2207: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;
2208: X_MSG_COUNT := 1;
2209: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2210: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2211: fnd_message.set_token('PROCEDURE','Add_Catalog_Descriptors');
2212: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
2213: fnd_message.retrieve(X_MSG_DATA);
2214: RETURN;

Line 2211: fnd_message.set_token('PROCEDURE','Add_Catalog_Descriptors');

2207: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;
2208: X_MSG_COUNT := 1;
2209: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2210: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2211: fnd_message.set_token('PROCEDURE','Add_Catalog_Descriptors');
2212: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
2213: fnd_message.retrieve(X_MSG_DATA);
2214: RETURN;
2215: END Add_Catalog_Descriptors;

Line 2212: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');

2208: X_MSG_COUNT := 1;
2209: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2210: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2211: fnd_message.set_token('PROCEDURE','Add_Catalog_Descriptors');
2212: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
2213: fnd_message.retrieve(X_MSG_DATA);
2214: RETURN;
2215: END Add_Catalog_Descriptors;
2216: /*============ADDED FOR SERVICES PROCUREMENT PROJECT=====================

Line 2213: fnd_message.retrieve(X_MSG_DATA);

2209: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2210: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2211: fnd_message.set_token('PROCEDURE','Add_Catalog_Descriptors');
2212: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
2213: fnd_message.retrieve(X_MSG_DATA);
2214: RETURN;
2215: END Add_Catalog_Descriptors;
2216: /*============ADDED FOR SERVICES PROCUREMENT PROJECT=====================
2217: PROCEDURE : Add_Price_Differential

Line 2307: fnd_message.set_name

2303: p_buyer_id -- last updated by
2304: );
2305: EXCEPTION
2306: WHEN OTHERS THEN
2307: fnd_message.set_name
2308: (
2309: 'PON', 'PON_AUC_PLSQL_ERR'
2310: )
2311: ;

Line 2312: fnd_message.set_token

2308: (
2309: 'PON', 'PON_AUC_PLSQL_ERR'
2310: )
2311: ;
2312: fnd_message.set_token
2313: (
2314: 'PACKAGE','pon_auction_interface_pkg'
2315: )
2316: ;

Line 2317: fnd_message.set_token

2313: (
2314: 'PACKAGE','pon_auction_interface_pkg'
2315: )
2316: ;
2317: fnd_message.set_token
2318: (
2319: 'PROCEDURE','Add_Price_Differential'
2320: )
2321: ;

Line 2322: fnd_message.set_token

2318: (
2319: 'PROCEDURE','Add_Price_Differential'
2320: )
2321: ;
2322: fnd_message.set_token
2323: (
2324: 'ERROR',v_debug_status || ' [' || SQLERRM || ']'
2325: )
2326: ;

Line 2376: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');

2372: EXCEPTION
2373: WHEN OTHERS THEN
2374: P_RESULT := error;
2375: P_ERROR_CODE := 'GET_NEG_OWNER';
2376: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2377: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2378: fnd_message.set_token('PROCEDURE','Get_Negotiation_Owner');
2379: fnd_message.set_token('ERROR','Document ' || P_DOCUMENT_NUMBER || ' [' || SQLERRM || ']');
2380: fnd_message.retrieve(P_ERROR_MESSAGE);

Line 2377: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

2373: WHEN OTHERS THEN
2374: P_RESULT := error;
2375: P_ERROR_CODE := 'GET_NEG_OWNER';
2376: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2377: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2378: fnd_message.set_token('PROCEDURE','Get_Negotiation_Owner');
2379: fnd_message.set_token('ERROR','Document ' || P_DOCUMENT_NUMBER || ' [' || SQLERRM || ']');
2380: fnd_message.retrieve(P_ERROR_MESSAGE);
2381: END;

Line 2378: fnd_message.set_token('PROCEDURE','Get_Negotiation_Owner');

2374: P_RESULT := error;
2375: P_ERROR_CODE := 'GET_NEG_OWNER';
2376: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2377: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2378: fnd_message.set_token('PROCEDURE','Get_Negotiation_Owner');
2379: fnd_message.set_token('ERROR','Document ' || P_DOCUMENT_NUMBER || ' [' || SQLERRM || ']');
2380: fnd_message.retrieve(P_ERROR_MESSAGE);
2381: END;
2382: /*========================================================================

Line 2379: fnd_message.set_token('ERROR','Document ' || P_DOCUMENT_NUMBER || ' [' || SQLERRM || ']');

2375: P_ERROR_CODE := 'GET_NEG_OWNER';
2376: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2377: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2378: fnd_message.set_token('PROCEDURE','Get_Negotiation_Owner');
2379: fnd_message.set_token('ERROR','Document ' || P_DOCUMENT_NUMBER || ' [' || SQLERRM || ']');
2380: fnd_message.retrieve(P_ERROR_MESSAGE);
2381: END;
2382: /*========================================================================
2383: PROCEDURE : Get_PO_Negotiation_Link PUBLIC

Line 2380: fnd_message.retrieve(P_ERROR_MESSAGE);

2376: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2377: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2378: fnd_message.set_token('PROCEDURE','Get_Negotiation_Owner');
2379: fnd_message.set_token('ERROR','Document ' || P_DOCUMENT_NUMBER || ' [' || SQLERRM || ']');
2380: fnd_message.retrieve(P_ERROR_MESSAGE);
2381: END;
2382: /*========================================================================
2383: PROCEDURE : Get_PO_Negotiation_Link PUBLIC
2384: PARAMETERS:

Line 2443: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');

2439: EXCEPTION
2440: WHEN OTHERS THEN
2441: P_RESULT := error;
2442: P_ERROR_CODE := 'GET_NEG_OWNER';
2443: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2444: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2445: fnd_message.set_token('PROCEDURE','Get_PO_Negotiation_Link');
2446: fnd_message.set_token('ERROR','PO Header ' || P_PO_HEADER_ID || ' [' || SQLERRM || ']');
2447: fnd_message.retrieve(P_ERROR_MESSAGE);

Line 2444: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

2440: WHEN OTHERS THEN
2441: P_RESULT := error;
2442: P_ERROR_CODE := 'GET_NEG_OWNER';
2443: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2444: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2445: fnd_message.set_token('PROCEDURE','Get_PO_Negotiation_Link');
2446: fnd_message.set_token('ERROR','PO Header ' || P_PO_HEADER_ID || ' [' || SQLERRM || ']');
2447: fnd_message.retrieve(P_ERROR_MESSAGE);
2448: END;

Line 2445: fnd_message.set_token('PROCEDURE','Get_PO_Negotiation_Link');

2441: P_RESULT := error;
2442: P_ERROR_CODE := 'GET_NEG_OWNER';
2443: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2444: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2445: fnd_message.set_token('PROCEDURE','Get_PO_Negotiation_Link');
2446: fnd_message.set_token('ERROR','PO Header ' || P_PO_HEADER_ID || ' [' || SQLERRM || ']');
2447: fnd_message.retrieve(P_ERROR_MESSAGE);
2448: END;
2449: --

Line 2446: fnd_message.set_token('ERROR','PO Header ' || P_PO_HEADER_ID || ' [' || SQLERRM || ']');

2442: P_ERROR_CODE := 'GET_NEG_OWNER';
2443: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2444: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2445: fnd_message.set_token('PROCEDURE','Get_PO_Negotiation_Link');
2446: fnd_message.set_token('ERROR','PO Header ' || P_PO_HEADER_ID || ' [' || SQLERRM || ']');
2447: fnd_message.retrieve(P_ERROR_MESSAGE);
2448: END;
2449: --
2450: /*===================================================================

Line 2447: fnd_message.retrieve(P_ERROR_MESSAGE);

2443: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2444: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2445: fnd_message.set_token('PROCEDURE','Get_PO_Negotiation_Link');
2446: fnd_message.set_token('ERROR','PO Header ' || P_PO_HEADER_ID || ' [' || SQLERRM || ']');
2447: fnd_message.retrieve(P_ERROR_MESSAGE);
2448: END;
2449: --
2450: /*===================================================================
2451: PROCEDURE: add_negotiation_invitees PUBLIC

Line 2589: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');

2585: RETURN;
2586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2588: x_msg_count := 1;
2589: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2590: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2591: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
2592: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
2593: fnd_message.retrieve(x_msg_data);

Line 2590: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

2586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2588: x_msg_count := 1;
2589: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2590: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2591: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
2592: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
2593: fnd_message.retrieve(x_msg_data);
2594: RETURN;

Line 2591: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');

2587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2588: x_msg_count := 1;
2589: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2590: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2591: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
2592: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
2593: fnd_message.retrieve(x_msg_data);
2594: RETURN;
2595: WHEN OTHERS THEN

Line 2592: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');

2588: x_msg_count := 1;
2589: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2590: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2591: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
2592: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
2593: fnd_message.retrieve(x_msg_data);
2594: RETURN;
2595: WHEN OTHERS THEN
2596: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 2593: fnd_message.retrieve(x_msg_data);

2589: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2590: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2591: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
2592: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
2593: fnd_message.retrieve(x_msg_data);
2594: RETURN;
2595: WHEN OTHERS THEN
2596: x_return_status := FND_API.G_RET_STS_ERROR ;
2597: x_msg_count := 1;

Line 2598: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');

2594: RETURN;
2595: WHEN OTHERS THEN
2596: x_return_status := FND_API.G_RET_STS_ERROR ;
2597: x_msg_count := 1;
2598: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2599: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2600: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
2601: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
2602: --APP_EXCEPTION.RAISE_EXCEPTION;

Line 2599: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

2595: WHEN OTHERS THEN
2596: x_return_status := FND_API.G_RET_STS_ERROR ;
2597: x_msg_count := 1;
2598: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2599: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2600: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
2601: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
2602: --APP_EXCEPTION.RAISE_EXCEPTION;
2603: fnd_message.retrieve(x_msg_data);

Line 2600: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');

2596: x_return_status := FND_API.G_RET_STS_ERROR ;
2597: x_msg_count := 1;
2598: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2599: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2600: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
2601: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
2602: --APP_EXCEPTION.RAISE_EXCEPTION;
2603: fnd_message.retrieve(x_msg_data);
2604: RETURN;

Line 2601: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');

2597: x_msg_count := 1;
2598: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2599: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2600: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
2601: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
2602: --APP_EXCEPTION.RAISE_EXCEPTION;
2603: fnd_message.retrieve(x_msg_data);
2604: RETURN;
2605: END;

Line 2603: fnd_message.retrieve(x_msg_data);

2599: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2600: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
2601: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
2602: --APP_EXCEPTION.RAISE_EXCEPTION;
2603: fnd_message.retrieve(x_msg_data);
2604: RETURN;
2605: END;
2606: -- API used by html autocreation for default negotiation style
2607: PROCEDURE get_default_negotiation_style

Line 2675: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');

2671: RETURN;
2672: WHEN OTHERS THEN
2673: x_return_status := FND_API.G_RET_STS_ERROR ;
2674: x_msg_count := 1;
2675: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2676: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2677: fnd_message.set_token('PROCEDURE','maintain_clm_relations');
2678: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
2679: --APP_EXCEPTION.RAISE_EXCEPTION;

Line 2676: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

2672: WHEN OTHERS THEN
2673: x_return_status := FND_API.G_RET_STS_ERROR ;
2674: x_msg_count := 1;
2675: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2676: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2677: fnd_message.set_token('PROCEDURE','maintain_clm_relations');
2678: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
2679: --APP_EXCEPTION.RAISE_EXCEPTION;
2680: fnd_message.retrieve(x_msg_data);

Line 2677: fnd_message.set_token('PROCEDURE','maintain_clm_relations');

2673: x_return_status := FND_API.G_RET_STS_ERROR ;
2674: x_msg_count := 1;
2675: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2676: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2677: fnd_message.set_token('PROCEDURE','maintain_clm_relations');
2678: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
2679: --APP_EXCEPTION.RAISE_EXCEPTION;
2680: fnd_message.retrieve(x_msg_data);
2681: logme(l_log_module, 'in OTHERS' || x_msg_data);

Line 2678: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');

2674: x_msg_count := 1;
2675: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2676: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2677: fnd_message.set_token('PROCEDURE','maintain_clm_relations');
2678: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
2679: --APP_EXCEPTION.RAISE_EXCEPTION;
2680: fnd_message.retrieve(x_msg_data);
2681: logme(l_log_module, 'in OTHERS' || x_msg_data);
2682: RETURN;

Line 2680: fnd_message.retrieve(x_msg_data);

2676: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2677: fnd_message.set_token('PROCEDURE','maintain_clm_relations');
2678: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
2679: --APP_EXCEPTION.RAISE_EXCEPTION;
2680: fnd_message.retrieve(x_msg_data);
2681: logme(l_log_module, 'in OTHERS' || x_msg_data);
2682: RETURN;
2683: END maintain_clm_relations;
2684: PROCEDURE maintain_clm_relations