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.PO_R12_CAT_UPG_VAL_PVT dependencies on PO_LINES_INTERFACE

Line 2753: -- p_table_name => 'PO_LINES_INTERFACE',

2749: --PO_R12_CAT_UPG_UTL.add_fatal_error(
2750: -- p_interface_header_id => l_interface_header_ids(i),
2751: -- p_interface_line_id => l_interface_line_ids(i),
2752: -- p_error_message_name => 'PO_PDOI_INVALID_ITEM_ID',
2753: -- p_table_name => 'PO_LINES_INTERFACE',
2754: -- p_column_name => 'ITEM_ID',
2755: -- p_column_value => l_item_id_list(i),
2756: -- p_token1_name => 'VALUE',
2757: -- p_token1_value => l_item_id_list(i)

Line 2884: -- p_table_name => 'PO_LINES_INTERFACE',

2880: --PO_R12_CAT_UPG_UTL.add_fatal_error(
2881: -- p_interface_header_id => l_interface_header_ids(i),
2882: -- p_interface_line_id => l_interface_line_ids(i),
2883: -- p_error_message_name => 'PO_PDOI_DIFF_ITEM_DESC',
2884: -- p_table_name => 'PO_LINES_INTERFACE',
2885: -- p_column_name => 'ITEM_DESCRIPTION',
2886: -- p_column_value => l_item_description_list(i)
2887: -- );
2888: END LOOP;

Line 2987: p_table_name => 'PO_LINES_INTERFACE',

2983: PO_R12_CAT_UPG_UTL.add_fatal_error(
2984: p_interface_header_id => p_lines_rec.interface_header_id(i),
2985: p_interface_line_id => p_lines_rec.interface_line_id(i),
2986: p_error_message_name => 'ICX_CAT_UOM_CODE_REQD',
2987: p_table_name => 'PO_LINES_INTERFACE',
2988: p_column_name => 'UOM_CODE',
2989: p_column_value => p_lines_rec.uom_code(i)
2990: );
2991: END IF;

Line 3062: p_table_name => 'PO_LINES_INTERFACE',

3058: PO_R12_CAT_UPG_UTL.add_fatal_error(
3059: p_interface_header_id => p_lines_rec.interface_header_id(i),
3060: p_interface_line_id => p_lines_rec.interface_line_id(i),
3061: p_error_message_name => 'ICX_CAT_INVALID_UOM_CODE',
3062: p_table_name => 'PO_LINES_INTERFACE',
3063: p_column_name => 'UOM_CODE',
3064: p_column_value => p_lines_rec.uom_code(i),
3065: p_token1_name => 'VALUE',
3066: p_token1_value => p_lines_rec.uom_code(i)

Line 3139: p_table_name => 'PO_LINES_INTERFACE',

3135: p_interface_header_id => l_interface_header_ids(i),
3136: p_interface_line_id => l_interface_line_ids(i),
3137: --p_error_message_name => 'PO_PDOI_INVALID_UOM_CODE',
3138: p_error_message_name => 'ICX_CAT_INVALID_UOM_CODE',
3139: p_table_name => 'PO_LINES_INTERFACE',
3140: p_column_name => 'UOM_CODE',
3141: p_column_value => l_uom_code_list(i),
3142: p_token1_name => 'VALUE',
3143: p_token1_value => l_uom_code_list(i)

Line 3227: -- p_table_name => 'PO_LINES_INTERFACE',

3223: --PO_R12_CAT_UPG_UTL.add_fatal_error(
3224: -- p_interface_header_id => p_lines_rec.interface_header_id(i),
3225: -- p_interface_line_id => p_lines_rec.interface_line_id(i),
3226: -- p_error_message_name => 'PO_COLUMN_NOT_NULL',
3227: -- p_table_name => 'PO_LINES_INTERFACE',
3228: -- p_column_name => 'ITEM_REVISION',
3229: -- p_column_value => p_lines_rec.item_revision(i)
3230: -- );
3231: END IF;

Line 3297: -- p_table_name => 'PO_LINES_INTERFACE',

3293: --PO_R12_CAT_UPG_UTL.add_fatal_error(
3294: -- p_interface_header_id => l_interface_header_ids(i),
3295: -- p_interface_line_id => l_interface_line_ids(i),
3296: -- p_error_message_name => 'PO_PDOI_ITEM_RELATED_INFO',
3297: -- p_table_name => 'PO_LINES_INTERFACE',
3298: -- p_column_name => 'ITEM_REVISION',
3299: -- p_column_value => l_item_revision_list(i),
3300: -- p_token1_name => 'COLUMN_NAME',
3301: -- p_token1_value => 'ITEM_REVISION',

Line 3458: p_table_name => 'PO_LINES_INTERFACE',

3454: PO_R12_CAT_UPG_UTL.add_fatal_error(
3455: p_interface_header_id => p_interface_header_id,
3456: p_interface_line_id => p_interface_line_id,
3457: p_error_message_name => 'ICX_CAT_SHOP_CATEG_REQD',
3458: p_table_name => 'PO_LINES_INTERFACE',
3459: p_column_name => 'IP_CATEGORY_ID',
3460: p_column_value => p_ip_category_id
3461: );
3462: END IF;

Line 3585: p_table_name => 'PO_LINES_INTERFACE',

3581: p_interface_header_id => p_lines_rec.interface_header_id(i),
3582: p_interface_line_id => p_lines_rec.interface_line_id(i),
3583: --p_error_message_name => 'PO_COLUMN_IS_NULL',
3584: p_error_message_name => 'ICX_CAT_CATEGORY_REQD',
3585: p_table_name => 'PO_LINES_INTERFACE',
3586: p_column_name => 'CATEGORY',
3587: p_column_value => l_ip_category_name, -- ECO bug 5584556
3588: p_token1_name => 'PO_CATEGORY_ID',
3589: p_token1_value => p_lines_rec.category(i), -- debug only, this is NULL here

Line 3691: p_table_name => 'PO_LINES_INTERFACE',

3687: p_interface_header_id => l_interface_header_ids(i),
3688: p_interface_line_id => l_interface_line_ids(i),
3689: --p_error_message_name => 'PO_PDOI_ITEM_RELATED_INFO',
3690: p_error_message_name => 'ICX_CAT_INVALID_CATEGORY',
3691: p_table_name => 'PO_LINES_INTERFACE',
3692: p_column_name => 'CATEGORY_ID',
3693: p_column_value => l_category_name, -- ECO bug 5584556
3694: p_token1_name => 'VALUE',
3695: p_token1_value => l_category_id_list(i),

Line 3779: p_table_name => 'PO_LINES_INTERFACE',

3775: p_interface_header_id => l_interface_header_ids(i),
3776: p_interface_line_id => l_interface_line_ids(i),
3777: --p_error_message_name => 'PO_PDOI_INVALID_CATEGORY_ID',
3778: p_error_message_name => 'ICX_CAT_INVALID_CATEGORY',
3779: p_table_name => 'PO_LINES_INTERFACE',
3780: p_column_name => 'CATEGORY_ID',
3781: p_column_value => l_category_name, -- ECO bug 5584556
3782: p_token1_name => 'VALUE',
3783: p_token1_value => l_category_id_list(i)

Line 3866: p_table_name => 'PO_LINES_INTERFACE',

3862: p_interface_header_id => l_interface_header_ids(i),
3863: p_interface_line_id => l_interface_line_ids(i),
3864: --p_error_message_name => 'PO_PDOI_INVALID_CATEGORY_ID',
3865: p_error_message_name => 'ICX_CAT_INVALID_CATEGORY',
3866: p_table_name => 'PO_LINES_INTERFACE',
3867: p_column_name => 'CATEGORY_ID',
3868: p_column_value => l_category_name, -- ECO bug 5584556
3869: p_token1_name => 'VALUE',
3870: p_token1_value => l_category_id_list(i)

Line 3954: p_table_name => 'PO_LINES_INTERFACE',

3950: p_interface_header_id => p_lines_rec.interface_header_id(i),
3951: p_interface_line_id => p_lines_rec.interface_line_id(i),
3952: --p_error_message_name => 'PO_PDOI_LT_ZERO',
3953: p_error_message_name => 'ICX_CAT_INVALID_PRICE',
3954: p_table_name => 'PO_LINES_INTERFACE',
3955: p_column_name => 'UNIT_PRICE',
3956: p_column_value => p_lines_rec.unit_price(i),
3957: p_token1_name => 'COLUMN_NAME',
3958: p_token1_value => 'UNIT_PRICE',

Line 4156: UPDATE PO_LINES_INTERFACE POLI

4152:
4153: -- SQL What: validate create action at line level
4154: -- SQL Why : To find incorrect action
4155: -- SQL Join: processing_id, action, interface_header_id
4156: UPDATE PO_LINES_INTERFACE POLI
4157: SET POLI.processing_id = -POLI.processing_id,
4158: POLI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4159: WHERE POLI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4160: AND POLI.action = 'ORIGINAL'

Line 4174: p_table_name => 'PO_LINES_INTERFACE',

4170: PO_R12_CAT_UPG_UTL.add_fatal_error(
4171: p_interface_header_id => l_err_header_ids(i),
4172: p_interface_line_id => l_err_line_ids(i),
4173: p_error_message_name => 'PO_CAT_UPG_ORIG_NOT_ALLOWED',
4174: p_table_name => 'PO_LINES_INTERFACE',
4175: p_column_name => 'ACTION'
4176: );
4177: END LOOP;
4178:

Line 4272: FROM PO_LINES_INTERFACE POLI

4268: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4269: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create
4270: AND (EXISTS
4271: (SELECT 'Invalid relationship with Line Level'
4272: FROM PO_LINES_INTERFACE POLI
4273: WHERE POLI.interface_line_id = POAI.interface_line_id
4274: AND ( -- Attribute Row for GBPA must have appr action at line level
4275: (POAI.req_template_name = g_NOT_REQUIRED_REQ_TEMPLATE AND
4276: POAI.req_template_line_num = g_NOT_REQUIRED_ID AND

Line 4325: FROM PO_LINES_INTERFACE POLI

4321: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4322: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create
4323: AND (EXISTS
4324: (SELECT 'Invalid relationship with Line Level'
4325: FROM PO_LINES_INTERFACE POLI
4326: WHERE POLI.interface_line_id = POAI.interface_line_id
4327: AND ( -- Attribute Row for ReqTemplate must have action as REQTEMPALTE at line level
4328: ((POAI.req_template_name <> g_NOT_REQUIRED_REQ_TEMPLATE OR
4329: POAI.req_template_line_num <> g_NOT_REQUIRED_ID) AND

Line 4511: FROM PO_LINES_INTERFACE POLI

4507: )
4508: OR
4509: (EXISTS
4510: (SELECT 'Invalid relationship with Line Level'
4511: FROM PO_LINES_INTERFACE POLI
4512: WHERE POLI.interface_line_id = POATI.interface_line_id
4513: AND ( -- Attribute Row for GBPA must have appr action at line level
4514: (POATI.req_template_name = g_NOT_REQUIRED_REQ_TEMPLATE AND
4515: POATI.req_template_line_num = g_NOT_REQUIRED_ID AND

Line 4681: UPDATE PO_LINES_INTERFACE POLI

4677:
4678: -- SQL What: validate ADD action at line level
4679: -- SQL Why : To find incorrect action
4680: -- SQL Join: processing_id, action, po_header_id
4681: UPDATE PO_LINES_INTERFACE POLI
4682: SET POLI.processing_id = -POLI.processing_id,
4683: POLI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4684: WHERE POLI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4685: AND POLI.action = PO_R12_CAT_UPG_PVT.g_action_line_create -- ADD

Line 4705: p_table_name => 'PO_LINES_INTERFACE',

4701: PO_R12_CAT_UPG_UTL.add_fatal_error(
4702: p_interface_header_id => l_err_header_ids(i),
4703: p_interface_line_id => l_err_line_ids(i),
4704: p_error_message_name => 'PO_CAT_UPG_INVALID_HEADER_ID',
4705: p_table_name => 'PO_LINES_INTERFACE',
4706: p_column_name => 'PO_HEADER_ID'
4707: );
4708: END LOOP;
4709:

Line 4919: UPDATE PO_LINES_INTERFACE POLI

4915:
4916: -- SQL What: validate update action at Line level
4917: -- SQL Why : To find incorrect action
4918: -- SQL Join: processing_id, action, po_line_id
4919: UPDATE PO_LINES_INTERFACE POLI
4920: SET POLI.processing_id = -POLI.processing_id,
4921: POLI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4922: WHERE POLI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4923: AND POLI.action = 'UPDATE'

Line 4942: p_table_name => 'po_lines_interface',

4938: PO_R12_CAT_UPG_UTL.add_fatal_error(
4939: p_interface_header_id => l_err_header_ids(i),
4940: p_interface_line_id => l_err_line_ids(i),
4941: p_error_message_name => 'PO_CAT_UPG_INVALID_LINE_ID',
4942: p_table_name => 'po_lines_interface',
4943: p_column_name => 'PO_LINE_ID'
4944: );
4945: END LOOP;
4946:

Line 5258: UPDATE PO_LINES_INTERFACE POLI

5254:
5255: -- SQL What: validate delete action at line level
5256: -- SQL Why : To find incorrect action
5257: -- SQL Join: processing_id, action, po_line_id
5258: UPDATE PO_LINES_INTERFACE POLI
5259: SET POLI.processing_id = -POLI.processing_id,
5260: POLI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
5261: WHERE POLI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
5262: AND POLI.action = 'DELETE'

Line 5282: p_table_name => 'po_lines_interface',

5278: PO_R12_CAT_UPG_UTL.add_fatal_error(
5279: p_interface_header_id => l_err_header_ids(i),
5280: p_interface_line_id => l_err_line_ids(i),
5281: p_error_message_name => 'PO_CAT_UPG_INVALID_LINE_ID',
5282: p_table_name => 'po_lines_interface',
5283: p_column_name => 'PO_LINE_ID'
5284: );
5285: END LOOP;
5286: