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.ICX_POR_ITEM_UPLOAD dependencies on ICX_POR_ITEM_UPLOAD

Line 1: PACKAGE BODY ICX_POR_ITEM_UPLOAD AS

1: PACKAGE BODY ICX_POR_ITEM_UPLOAD AS
2: /* $Header: ICXIULDB.pls 115.72 2004/08/03 00:58:30 kaholee ship $ */
3:
4: -- Interface table row
5: type tRootDescriptors is table of Varchar2(700) index by binary_integer;

Line 321: 'Exception at ICX_POR_ITEM_UPLOAD.get_distinct('

317: WHEN OTHERS THEN
318: ROLLBACK;
319:
320: RAISE_APPLICATION_ERROR(-20000,
321: 'Exception at ICX_POR_ITEM_UPLOAD.get_distinct('
322: || xErrLoc || '): ' || SQLERRM);
323: END get_distinct;
324:
325: /* Constructs the SQL statements used to populate ICX_POR_CTX_TL

Line 354: 'Exception at ICX_POR_ITEM_UPLOAD.build_category_ctx_sql('

350: WHEN OTHERS THEN
351: ROLLBACK;
352:
353: RAISE_APPLICATION_ERROR(-20000,
354: 'Exception at ICX_POR_ITEM_UPLOAD.build_category_ctx_sql('
355: || xErrLoc || '): ' || SQLERRM);
356: END build_category_ctx_sql;
357:
358: /* Constructs the SQL statements used to populate ICX_POR_C######_TL for

Line 532: 'Exception at ICX_POR_ITEM_UPLOAD.build_category_sql('

528: WHEN OTHERS THEN
529: ROLLBACK;
530:
531: RAISE_APPLICATION_ERROR(-20000,
532: 'Exception at ICX_POR_ITEM_UPLOAD.build_category_sql('
533: || xErrLoc || '): ' || SQLERRM);
534: END build_category_sql;
535:
536: /* Loads information about the categories in the current batch */

Line 584: 'Exception at ICX_POR_ITEM_UPLOAD.load_distinct_categories('

580: WHEN OTHERS THEN
581: ROLLBACK;
582:
583: RAISE_APPLICATION_ERROR(-20000,
584: 'Exception at ICX_POR_ITEM_UPLOAD.load_distinct_categories('
585: || xErrLoc || '): ' || SQLERRM);
586: END load_distinct_categories;
587:
588: /* Constructs the SQL used to populate ICX_POR_ITEMS and ICX_POR_ITEMS_TL */

Line 765: 'Exception at ICX_POR_ITEM_UPLOAD.build_root_sql('

761: WHEN OTHERS THEN
762: ROLLBACK;
763:
764: RAISE_APPLICATION_ERROR(-20000,
765: 'Exception at ICX_POR_ITEM_UPLOAD.build_root_sql('
766: || xErrLoc || '): ' || SQLERRM);
767: END build_root_sql;
768:
769: /* Processes the new prices in the current batch */

Line 837: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_add_prices('

833: WHEN OTHERS THEN
834: ROLLBACK;
835:
836: RAISE_APPLICATION_ERROR(-20000,
837: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_add_prices('
838: || xErrLoc || '): ' || SQLERRM);
839: END process_batch_add_prices;
840:
841: /* Processes the price updates in the current batch */

Line 1057: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_addupdate_prices('

1053: WHEN OTHERS THEN
1054: ROLLBACK;
1055:
1056: RAISE_APPLICATION_ERROR(-20000,
1057: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_addupdate_prices('
1058: || xErrLoc || '): ' || SQLERRM);
1059: END process_batch_addupdate_prices;
1060:
1061: PROCEDURE process_batch_addupdate_prices(p_batch_type IN VARCHAR2,

Line 1082: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_addupdate_prices('

1078: WHEN OTHERS THEN
1079: ROLLBACK;
1080:
1081: RAISE_APPLICATION_ERROR(-20000,
1082: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_addupdate_prices('
1083: || xErrLoc || ') 2 arg: ' || SQLERRM);
1084: END process_batch_addupdate_prices;
1085:
1086: /* Processes the price deletes in the current batch */

Line 1175: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_delete_prices('

1171: WHEN OTHERS THEN
1172: ROLLBACK;
1173:
1174: RAISE_APPLICATION_ERROR(-20000,
1175: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_delete_prices('
1176: || xErrLoc || '): ' || SQLERRM);
1177: END process_batch_delete_prices;
1178:
1179: /* Populates ICX_POR_CATEGORY_ITEMS for items in the current batch

Line 1238: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_common('

1234: WHEN OTHERS THEN
1235: ROLLBACK;
1236:
1237: RAISE_APPLICATION_ERROR(-20000,
1238: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_common('
1239: || xErrLoc || '): ' || SQLERRM);
1240: END process_batch_common;
1241:
1242: /* Processes the new items in the current batch */

Line 1688: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_add('

1684: WHEN OTHERS THEN
1685: ROLLBACK;
1686:
1687: RAISE_APPLICATION_ERROR(-20000,
1688: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_add('
1689: || xErrLoc || '): ' || SQLERRM);
1690: END process_batch_add;
1691:
1692: /* Processes the item updates in the current batch */

Line 1902: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_update('

1898: DBMS_SQL.close_cursor(v_cursor_id);
1899: END IF;
1900:
1901: RAISE_APPLICATION_ERROR(-20000,
1902: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_update('
1903: || xErrLoc || '): ' || SQLERRM);
1904: END process_batch_update;
1905:
1906: /* Processes the item deletions in the current batch */

Line 1963: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_delete('

1959: WHEN OTHERS THEN
1960: ROLLBACK;
1961:
1962: RAISE_APPLICATION_ERROR(-20000,
1963: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_delete('
1964: || xErrLoc || '): ' || SQLERRM);
1965: END process_batch_delete;
1966:
1967: /* Processes the item translations in the current batch */

Line 2142: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_translate('

2138: DBMS_SQL.close_cursor(v_cursor_id);
2139: END IF;
2140:
2141: RAISE_APPLICATION_ERROR(-20000,
2142: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_translate('
2143: || xErrLoc || '): ' || SQLERRM);
2144: END process_batch_translate;
2145:
2146: /* Processes the current price batch*/

Line 2167: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_prices('

2163: WHEN OTHERS THEN
2164: ROLLBACK;
2165:
2166: RAISE_APPLICATION_ERROR(-20000,
2167: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_prices('
2168: || xErrLoc || '): ' || SQLERRM);
2169: END process_batch_prices;
2170:
2171: /* Processes the current item batch */

Line 2236: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_items('

2232: WHEN OTHERS THEN
2233: ROLLBACK;
2234:
2235: RAISE_APPLICATION_ERROR(-20000,
2236: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_items('
2237: || xErrLoc || '): ' || SQLERRM);
2238: END process_batch_items;
2239:
2240: /**

Line 2311: 'Exception at ICX_POR_ITEM_UPLOAD.save_failed_line_message('

2307: WHEN OTHERS THEN
2308: ROLLBACK;
2309:
2310: RAISE_APPLICATION_ERROR(-20000,
2311: 'Exception at ICX_POR_ITEM_UPLOAD.save_failed_line_message('
2312: || xErrLoc || '): ' || SQLERRM);
2313:
2314: END save_failed_line_message;
2315:

Line 2345: 'Exception at ICX_POR_ITEM_UPLOAD.fetch_local_descriptors('

2341: WHEN OTHERS THEN
2342: ROLLBACK;
2343:
2344: RAISE_APPLICATION_ERROR(-20000,
2345: 'Exception at ICX_POR_ITEM_UPLOAD.fetch_local_descriptors('
2346: || xErrLoc || '): ' || SQLERRM);
2347: END fetch_local_descriptors;
2348:
2349: /* Saves a failed item */

Line 3102: 'Exception at ICX_POR_ITEM_UPLOAD.save_failed_item('

3098: WHEN OTHERS THEN
3099: ROLLBACK;
3100:
3101: RAISE_APPLICATION_ERROR(-20000,
3102: 'Exception at ICX_POR_ITEM_UPLOAD.save_failed_item('
3103: || xErrLoc || '): ' || SQLERRM);
3104: END save_failed_item;
3105:
3106: /* Saves a failed price */

Line 3241: 'Exception at ICX_POR_ITEM_UPLOAD.save_failed_price('

3237: EXCEPTION
3238: WHEN OTHERS THEN
3239: ROLLBACK;
3240: RAISE_APPLICATION_ERROR(-20000,
3241: 'Exception at ICX_POR_ITEM_UPLOAD.save_failed_price('
3242: || xErrLoc || '): ' || SQLERRM);
3243: END save_failed_price;
3244:
3245: /** Proc : save_required_descriptor_errors

Line 3334: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_price_errors('

3330: WHEN OTHERS THEN
3331: ROLLBACK;
3332:
3333: RAISE_APPLICATION_ERROR(-20000,
3334: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_price_errors('
3335: || xErrLoc || '): ' || SQLERRM);
3336: END process_batch_price_errors;
3337:
3338: /* Processes failed items in the current batch */

Line 3394: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_item_errors('

3390: WHEN OTHERS THEN
3391: ROLLBACK;
3392:
3393: RAISE_APPLICATION_ERROR(-20000,
3394: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_item_errors('
3395: || xErrLoc || '): ' || SQLERRM);
3396: END process_batch_item_errors;
3397:
3398: /* Saves the error message for duplicate lines */

Line 3419: 'Exception at ICX_POR_ITEM_UPLOAD.reject_line: ' || SQLERRM);

3415: EXCEPTION
3416: WHEN OTHERS THEN
3417: ROLLBACK;
3418: RAISE_APPLICATION_ERROR(-20000,
3419: 'Exception at ICX_POR_ITEM_UPLOAD.reject_line: ' || SQLERRM);
3420: END reject_line;
3421:
3422: /* Fail the duplicate prices. This needs to be done before processing
3423: prices since we want to avoid sorting every time. */

Line 3526: 'Exception at ICX_POR_ITEM_UPLOAD.reject_duplicate_prices('

3522:
3523: ROLLBACK;
3524:
3525: RAISE_APPLICATION_ERROR(-20000,
3526: 'Exception at ICX_POR_ITEM_UPLOAD.reject_duplicate_prices('
3527: || xErrLoc || '): ' || SQLERRM);
3528: END reject_duplicate_prices;
3529:
3530:

Line 3759: 'Exception at ICX_POR_ITEM_UPLOAD.move_prices('

3755:
3756: ROLLBACK;
3757:
3758: RAISE_APPLICATION_ERROR(-20000,
3759: 'Exception at ICX_POR_ITEM_UPLOAD.move_prices('
3760: || xErrLoc || '): ' || SQLERRM);
3761: END move_prices;
3762:
3763: PROCEDURE reject_duplicates IS

Line 3895: 'Exception at ICX_POR_ITEM_UPLOAD.reject_duplicates('

3891:
3892: ROLLBACK;
3893:
3894: RAISE_APPLICATION_ERROR(-20000,
3895: 'Exception at ICX_POR_ITEM_UPLOAD.reject_duplicates('
3896: || xErrLoc || '): ' || SQLERRM);
3897: END reject_duplicates;
3898:
3899: /*Processes the valid items*/

Line 4222: 'Exception at ICX_POR_ITEM_UPLOAD.move_items('

4218:
4219: ROLLBACK;
4220:
4221: RAISE_APPLICATION_ERROR(-20000,
4222: 'Exception at ICX_POR_ITEM_UPLOAD.move_items('
4223: || xErrLoc || '): ' || SQLERRM);
4224: END move_items;
4225:
4226: /* Processes the lines for a given job */

Line 4309: 'Exception at ICX_POR_ITEM_UPLOAD.move_data('

4305: WHEN OTHERS THEN
4306: ROLLBACK;
4307:
4308: RAISE_APPLICATION_ERROR(-20000,
4309: 'Exception at ICX_POR_ITEM_UPLOAD.move_data('
4310: || xErrLoc || '): ' || SQLERRM);
4311: END move_data;
4312:
4313: PROCEDURE move_unsaved_failed_lines(p_request_id IN NUMBER,

Line 4402: 'Exception at ICX_POR_ITEM_UPLOAD.move_unsaved_failed_lines('

4398: WHEN OTHERS THEN
4399: ROLLBACK;
4400:
4401: RAISE_APPLICATION_ERROR(-20000,
4402: 'Exception at ICX_POR_ITEM_UPLOAD.move_unsaved_failed_lines('
4403: || xErrLoc || '): ' || SQLERRM);
4404: END move_unsaved_failed_lines;
4405:
4406: PROCEDURE create_price_list(p_price_list_name IN VARCHAR2,

Line 4448: 'Exception at ICX_POR_ITEM_UPLOAD.create_price_list('

4444: WHEN OTHERS THEN
4445: ROLLBACK;
4446:
4447: RAISE_APPLICATION_ERROR(-20000,
4448: 'Exception at ICX_POR_ITEM_UPLOAD.create_price_list('
4449: || xErrLoc || '): ' || SQLERRM);
4450: END create_price_list;
4451:
4452: PROCEDURE update_price_list( p_header_id IN NUMBER,

Line 4502: 'Exception at ICX_POR_ITEM_UPLOAD.update_price_list('

4498: WHEN OTHERS THEN
4499: ROLLBACK;
4500:
4501: RAISE_APPLICATION_ERROR(-20000,
4502: 'Exception at ICX_POR_ITEM_UPLOAD.update_price_list('
4503: || xErrLoc || '): ' || SQLERRM);
4504: END update_price_list;
4505:
4506: PROCEDURE delete_price_list( p_header_id IN NUMBER ) IS

Line 4520: 'Exception at ICX_POR_ITEM_UPLOAD.delete_price_list('

4516: WHEN OTHERS THEN
4517: ROLLBACK;
4518:
4519: RAISE_APPLICATION_ERROR(-20000,
4520: 'Exception at ICX_POR_ITEM_UPLOAD.delete_price_list('
4521: || xErrLoc || '): ' || SQLERRM);
4522: END delete_price_list;
4523:
4524: --Bug#2709997: Pass in supplier site code also

Line 4708: ICX_POR_ITEM_UPLOAD.save_failed_line_message(l_contracts.request_id,

4704: l_contracts.buyer_name,
4705: l_contracts.contract_reference_num);
4706:
4707: l_progress := '300';
4708: ICX_POR_ITEM_UPLOAD.save_failed_line_message(l_contracts.request_id,
4709: l_contracts.line_number,
4710: l_contracts.error_message);
4711: end if;
4712: END LOOP;

Line 4717: 'ICX_POR_ITEM_UPLOAD.save_failed_admin_data '||

4713:
4714: EXCEPTION
4715: WHEN OTHERS then
4716: RAISE_APPLICATION_ERROR (-20000, 'Exception at '||
4717: 'ICX_POR_ITEM_UPLOAD.save_failed_admin_data '||
4718: '(ErrLoc = ' || l_progress ||') ' ||
4719: 'SQL Error : ' || SQLERRM);
4720:
4721: END save_failed_admin_data;

Line 4811: 'ICX_POR_ITEM_UPLOAD.validate_contracts' ||

4807: exception
4808: when others then
4809: Debug('[validate_contracts-'||l_progress||'] '||SQLERRM);
4810: RAISE_APPLICATION_ERROR (-20000, 'Exception at ' ||
4811: 'ICX_POR_ITEM_UPLOAD.validate_contracts' ||
4812: '(ErrLoc = ' || l_progress ||') ' ||
4813: 'SQL Error : ' || SQLERRM);
4814:
4815: end ;

Line 4890: (-20000, 'Exception at ICX_POR_ITEM_UPLOAD.get_contracts_pass_failed(ErrLoc = ' || l_progress ||') ' ||

4886:
4887: EXCEPTION
4888: WHEN OTHERS then
4889: RAISE_APPLICATION_ERROR
4890: (-20000, 'Exception at ICX_POR_ITEM_UPLOAD.get_contracts_pass_failed(ErrLoc = ' || l_progress ||') ' ||
4891: 'SQL Error : ' || SQLERRM);
4892: END;
4893:
4894: --

Line 4926: 'ICX_POR_ITEM_UPLOAD.save_failed_admin' ||

4922:
4923: EXCEPTION
4924: WHEN OTHERS then
4925: RAISE_APPLICATION_ERROR (-20000, 'Exception at ' ||
4926: 'ICX_POR_ITEM_UPLOAD.save_failed_admin' ||
4927: '(ErrLoc = ' || l_progress ||') ' ||
4928: 'SQL Error : ' || SQLERRM);
4929: END save_failed_admin;
4930:

Line 4962: ICX_POR_ITEM_UPLOAD.save_failed_line_message(p_request_id,

4958: delete from icx_por_failed_line_messages
4959: where job_number = p_request_id;
4960:
4961: -- Save the Failed Line message now
4962: ICX_POR_ITEM_UPLOAD.save_failed_line_message(p_request_id,
4963: 1,
4964: p_error_message);
4965:
4966: EXCEPTION

Line 4969: 'ICX_POR_ITEM_UPLOAD.reject_catalog' ||

4965:
4966: EXCEPTION
4967: WHEN OTHERS then
4968: RAISE_APPLICATION_ERROR (-20000, 'Exception at ' ||
4969: 'ICX_POR_ITEM_UPLOAD.reject_catalog' ||
4970: '(ErrLoc = ' || l_progress ||') ' ||
4971: 'SQL Error : ' || SQLERRM);
4972: END reject_catalog;
4973:

Line 5082: (-20000, 'Exception at ICX_POR_ITEM_UPLOAD.handle_category_change(ErrLoc = ' || l_progress ||') ' ||

5078:
5079: EXCEPTION
5080: WHEN OTHERS then
5081: RAISE_APPLICATION_ERROR
5082: (-20000, 'Exception at ICX_POR_ITEM_UPLOAD.handle_category_change(ErrLoc = ' || l_progress ||') ' ||
5083: 'SQL Error : ' || SQLERRM);
5084: END handle_category_change;
5085:
5086: END ICX_POR_ITEM_UPLOAD;

Line 5086: END ICX_POR_ITEM_UPLOAD;

5082: (-20000, 'Exception at ICX_POR_ITEM_UPLOAD.handle_category_change(ErrLoc = ' || l_progress ||') ' ||
5083: 'SQL Error : ' || SQLERRM);
5084: END handle_category_change;
5085:
5086: END ICX_POR_ITEM_UPLOAD;