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.ENG_VAL_TO_ID dependencies on ERROR_HANDLER

Line 6: g_Token_Tbl Error_Handler.Token_Tbl_Type;

2: /* $Header: ENGSVIDB.pls 120.11 2011/11/28 09:16:00 rambkond ship $ */
3: -- Global constant holding the package name
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ENG_Val_To_Id';
6: g_Token_Tbl Error_Handler.Token_Tbl_Type;
7:
8: -- Prototypes for val_to_id functions.
9:
10: -- START GEN val_to_id

Line 1034: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

1030: PROCEDURE Change_Order_VID
1031: ( p_ECO_rec IN Eng_Eco_Pub.ECO_Rec_Type
1032: , p_old_eco_unexp_rec IN Eng_Eco_Pub.ECO_Unexposed_Rec_Type
1033: , P_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.ECO_Unexposed_Rec_Type
1034: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1035: , x_return_status OUT NOCOPY VARCHAR2
1036: )
1037: IS
1038: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 1038: l_Token_Tbl Error_Handler.Token_Tbl_Type;

1034: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1035: , x_return_status OUT NOCOPY VARCHAR2
1036: )
1037: IS
1038: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1039: l_change_order_type_id NUMBER;
1040: l_change_mgmt_type_code VARCHAR2(30);
1041: l_disable_date DATE;
1042: l_object_id NUMBER;

Line 1043: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

1039: l_change_order_type_id NUMBER;
1040: l_change_mgmt_type_code VARCHAR2(30);
1041: l_disable_date DATE;
1042: l_object_id NUMBER;
1043: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1044: l_err_text VARCHAR2(2000);
1045:
1046: l_change_type_code VARCHAR2(80);
1047: l_change_mgmt_type_name VARCHAR2(45);

Line 1088: Error_Handler.Add_Error_Token

1084: l_token_tbl(2).token_value := l_change_mgmt_type_name;
1085:
1086: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1087: THEN
1088: Error_Handler.Add_Error_Token
1089: (
1090: p_Message_Name => 'ENG_CHANGE_MGMT_TYPE_INVALID'
1091: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1092: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1125: Error_Handler.Add_Error_Token

1121: l_token_tbl(2).token_value := l_change_type_code;
1122:
1123: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1124: THEN
1125: Error_Handler.Add_Error_Token
1126: ( p_Message_Name => 'ENG_CHANGE_TYPE_INVALID'
1127: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1128: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1129: , p_Token_Tbl => l_Token_Tbl

Line 1139: Error_Handler.Add_Error_Token

1135: ELSIF l_change_order_type_id = FND_API.G_MISS_NUM
1136: THEN
1137: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1138: THEN
1139: Error_Handler.Add_Error_Token
1140: ( p_Message_Text => l_err_text
1141: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1142: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1143: );

Line 1158: Error_Handler.Add_Error_Token

1154: IF l_transaction_type = Bom_GLOBALS.G_OPR_CREATE
1155: THEN
1156: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1157: THEN
1158: Error_Handler.Add_Error_Token
1159: ( p_Message_Name => 'ENG_CHANGE_TYPE_MISSING'
1160: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1161: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1162: , p_Token_Tbl => l_Token_Tbl

Line 1182: Error_Handler.Add_Error_Token

1178: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1179: THEN
1180: l_token_tbl(2).token_name := 'CHANGE_TYPE_CODE';
1181: l_token_tbl(2).token_value := l_change_type_code;
1182: Error_Handler.Add_Error_Token
1183: ( p_Message_Name => 'ENG_CHANGE_TYPE_DISABLED'
1184: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1185: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1186: , p_Token_Tbl => l_Token_Tbl

Line 1213: Error_Handler.Add_Error_Token

1209: THEN
1210: l_token_tbl(1).token_name := 'STATUS_TYPE';
1211: l_token_tbl(1).token_value := p_ECO_rec.Status_Name;
1212:
1213: Error_Handler.Add_Error_Token
1214: ( p_message_name => 'ENG_STATUS_TYPE_INVALID'
1215: , p_mesg_token_tbl => l_mesg_token_tbl
1216: , p_token_tbl => l_token_tbl
1217: , x_mesg_token_tbl => l_mesg_token_tbl

Line 1853: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

1849: * revised item entity.
1850: ****************************************************************************/
1851: PROCEDURE Revised_Item_VID
1852: ( x_Return_Status OUT NOCOPY VARCHAR2
1853: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1854: , p_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1855: , x_rev_item_unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1856: , p_revised_item_Rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
1857: )

Line 1861: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

1857: )
1858: IS
1859: l_return_value NUMBER;
1860: l_Return_Status VARCHAR2(1);
1861: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1862: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1863: l_Rev_Item_Unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
1864: l_Err_Text VARCHAR2(2000);
1865: l_bill_seq_id NUMBER;

Line 1862: l_Token_Tbl Error_Handler.Token_Tbl_Type;

1858: IS
1859: l_return_value NUMBER;
1860: l_Return_Status VARCHAR2(1);
1861: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1862: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1863: l_Rev_Item_Unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
1864: l_Err_Text VARCHAR2(2000);
1865: l_bill_seq_id NUMBER;
1866: l_eco_type VARCHAR2(3);

Line 1896: Error_Handler.Add_Error_Token

1892: l_token_tbl(2).token_name := 'ORGANIZATION_CODE';
1893: l_token_tbl(2).token_value :=
1894: p_revised_item_rec.organization_code;
1895:
1896: Error_Handler.Add_Error_Token
1897: ( p_Message_Name =>'ENG_USE_UP_ITEM_ID_VID_INVALID'
1898: , p_Message_Text => NULL
1899: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1900: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1922: Error_Handler.Add_Error_Token

1918: );
1919:
1920: IF l_err_text IS NOT NULL
1921: THEN
1922: Error_Handler.Add_Error_Token
1923: ( p_Message_Name => NULL
1924: , p_Message_Text => l_err_text
1925: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1926: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1938: Error_Handler.Add_Error_Token

1934: l_token_tbl(2).token_name := 'REVISED_ITEM_NAME';
1935: l_token_tbl(2).token_value :=
1936: p_revised_item_rec.organization_code;
1937:
1938: Error_Handler.Add_Error_Token
1939: ( p_Message_Name => 'ENG_RIT_REQUESTOR_INVALID'
1940: , p_Message_Text => NULL
1941: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1942: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1970: Error_Handler.Add_Error_Token

1966: );
1967:
1968: IF l_err_text IS NOT NULL
1969: THEN
1970: Error_Handler.Add_Error_Token
1971: ( p_Message_Name => NULL
1972: , p_Message_Text => l_err_text
1973: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1974: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1986: Error_Handler.Add_Error_Token

1982: l_token_tbl(2).token_name := 'REVISED_ITEM_NAME';
1983: l_token_tbl(2).token_value :=
1984: p_revised_item_rec.revised_item_name ;
1985:
1986: Error_Handler.Add_Error_Token
1987: ( p_Message_Name => 'ENG_RIT_FROM_WO_INVALID'
1988: , p_Message_Text => NULL
1989: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1990: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2009: Error_Handler.Add_Error_Token

2005: );
2006:
2007: IF l_err_text IS NOT NULL
2008: THEN
2009: Error_Handler.Add_Error_Token
2010: ( p_Message_Name => NULL
2011: , p_Message_Text => l_err_text
2012: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2013: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2025: Error_Handler.Add_Error_Token

2021: l_token_tbl(2).token_name := 'REVISED_ITEM_NAME';
2022: l_token_tbl(2).token_value :=
2023: p_revised_item_rec.revised_item_name ;
2024:
2025: Error_Handler.Add_Error_Token
2026: ( p_Message_Name => 'ENG_RIT_TO_WO_INVALID'
2027: , p_Message_Text => NULL
2028: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2029: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2051: Error_Handler.Add_Error_Token

2047: , x_err_text => l_err_text
2048: );
2049: IF l_err_text IS NOT NULL
2050: THEN
2051: Error_Handler.Add_Error_Token
2052: ( p_Message_Name => NULL
2053: , p_Message_Text => l_err_text
2054: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2055: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2067: Error_Handler.Add_Error_Token

2063: l_token_tbl(2).token_name := 'REVISED_ITEM_NAME';
2064: l_token_tbl(2).token_value :=
2065: p_revised_item_rec.revised_item_name ;
2066:
2067: Error_Handler.Add_Error_Token
2068: ( p_Message_Name => 'ENG_RIT_LOCATION_NAME_INVALID'
2069: , p_Message_Text => NULL
2070: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2071: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2098: Error_Handler.Write_Debug('Getting Bill Seq Id . . . : ' ||

2094: , x_err_text => l_err_text
2095: );
2096:
2097: IF Bom_Globals.Get_Debug = 'Y' THEN
2098: Error_Handler.Write_Debug('Getting Bill Seq Id . . . : ' ||
2099: to_char(l_rev_item_unexp_rec.bill_sequence_id));
2100: END IF;
2101:
2102: END IF;

Line 2122: Error_Handler.Write_Debug('Getting Routing Seq Id . . . : ' ||

2118: );
2119:
2120:
2121: IF Bom_Globals.Get_Debug = 'Y' THEN
2122: Error_Handler.Write_Debug('Getting Routing Seq Id . . . : ' ||
2123: to_char(l_rev_item_unexp_rec.routing_sequence_id));
2124: END IF;
2125:
2126: END IF;

Line 2205: Error_Handler.Write_Debug('Getting From Revision Id . . . : ' ||

2201: , x_err_text => l_err_text
2202: );
2203: IF Bom_Globals.Get_Debug = 'Y'
2204: THEN
2205: Error_Handler.Write_Debug('Getting From Revision Id . . . : ' ||
2206: to_char(l_rev_item_unexp_rec.from_item_revision_id));
2207: END IF;
2208:
2209: IF ( l_rev_item_unexp_rec.from_item_revision_id IS NULL OR

Line 2217: Error_Handler.Add_Error_Token

2213: l_token_tbl(1).token_value := l_rev_item_unexp_rec.from_item_revision_id ;
2214: l_token_tbl(2).token_name := 'REVISED_ITEM_NAME';
2215: l_token_tbl(2).token_value := p_revised_item_rec.revised_item_name ;
2216:
2217: Error_Handler.Add_Error_Token
2218: ( p_Message_Name => 'ENG_INVALID_FROM_REVISION'
2219: , p_Message_Text => NULL
2220: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2221: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2249: Error_Handler.Add_Error_Token

2245: l_token_tbl(1).token_value := p_revised_item_rec.new_revision_reason ;
2246: l_token_tbl(2).token_name := 'REVISED_ITEM_NAME';
2247: l_token_tbl(2).token_value := p_revised_item_rec.revised_item_name ;
2248:
2249: Error_Handler.Add_Error_Token
2250: ( p_Message_Name => 'ENG_INVALID_REVISION_REASON'
2251: , p_Message_Text => NULL
2252: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2253: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2261: Error_Handler.Write_Debug('Getting New Revision reason Code . . . : ' ||

2257: END IF;
2258:
2259: IF Bom_Globals.Get_Debug = 'Y'
2260: THEN
2261: Error_Handler.Write_Debug('Getting New Revision reason Code . . . : ' ||
2262: l_rev_item_unexp_rec.new_revision_reason_code); -- bug 4309885: removed to_char(varchar) as it is not supported in 8i
2263: END IF;
2264: END IF;
2265: END IF; -- End of (l_eco_type = 'PLM')

Line 2281: Error_Handler.Add_Error_Token

2277: , x_err_text => l_err_text
2278: );
2279: IF l_err_text IS NOT NULL
2280: THEN
2281: Error_Handler.Add_Error_Token
2282: ( p_Message_Name => NULL
2283: , p_Message_Text => l_err_text
2284: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2285: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2297: Error_Handler.Add_Error_Token

2293: l_token_tbl(2).token_name := 'REVISED_ITEM_NAME';
2294: l_token_tbl(2).token_value :=
2295: p_revised_item_rec.revised_item_name ;
2296:
2297: Error_Handler.Add_Error_Token
2298: ( p_Message_Name => 'ENG_STRUC_TYPE_NAME_INVALID'
2299: , p_Message_Text => NULL
2300: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2301: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2317: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

2313:
2314:
2315: PROCEDURE ECO_Header_VID
2316: ( x_Return_Status OUT NOCOPY VARCHAR2
2317: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2318: , p_ECO_Rec IN Eng_Eco_Pub.ECO_Rec_Type
2319: , p_ECO_Unexp_Rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
2320: , x_ECO_Unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
2321: )

Line 2326: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

2322: IS
2323: l_err_text VARCHAR2(2000) := NULL;
2324: l_return_value NUMBER;
2325: l_Return_Status VARCHAR2(1);
2326: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2327: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2328: l_ECO_Unexp_Rec Eng_Eco_Pub.Eco_Unexposed_Rec_Type;
2329:
2330:

Line 2327: l_Token_Tbl Error_Handler.Token_Tbl_Type;

2323: l_err_text VARCHAR2(2000) := NULL;
2324: l_return_value NUMBER;
2325: l_Return_Status VARCHAR2(1);
2326: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2327: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2328: l_ECO_Unexp_Rec Eng_Eco_Pub.Eco_Unexposed_Rec_Type;
2329:
2330:
2331: l_change_mgmt_type_code VARCHAR2(30) ;

Line 2373: Error_Handler.Add_Error_Token

2369: l_token_tbl(2).token_value := p_ECO_rec.ECO_name;
2370: l_token_tbl(1).token_name := 'APPROVAL_LIST_NAME';
2371: l_token_tbl(1).token_value := p_ECO_rec.Approval_List_Name;
2372:
2373: Error_Handler.Add_Error_Token
2374: ( p_Message_Name => 'ENG_APPROVAL_LIST_INVALID'
2375: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2376: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2377: , p_Token_Tbl => l_Token_Tbl

Line 2387: Error_Handler.Add_Error_Token

2383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2384:
2385: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2386: THEN
2387: Error_Handler.Add_Error_Token
2388: ( p_Message_Text => l_err_text
2389: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2390: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2391: );

Line 2425: Error_Handler.Add_Error_Token

2421: l_token_tbl(2).token_value := p_ECO_rec.ECO_name;
2422: l_token_tbl(1).token_name := 'ECO_DEPARTMENT';
2423: l_token_tbl(1).token_value := p_ECO_rec.ECO_Department_name;
2424:
2425: Error_Handler.Add_Error_Token
2426: ( p_Message_Name => 'ENG_RESP_ORG_INVALID'
2427: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2428: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2429: , p_Token_Tbl => l_Token_Tbl

Line 2439: Error_Handler.Add_Error_Token

2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2436:
2437: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2438: THEN
2439: Error_Handler.Add_Error_Token
2440: ( p_Message_Text => l_err_text
2441: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2442: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2443: );

Line 2472: Error_Handler.Add_Error_Token(

2468: l_token_tbl(2).token_value := p_ECO_rec.ECO_name;
2469: l_token_tbl(1).token_name := 'EMPLOYEE_NUMBER';
2470: l_token_tbl(1).token_value := p_ECO_rec.employee_number;
2471:
2472: Error_Handler.Add_Error_Token(
2473: p_Message_Name => 'ENG_EMP_NUMBER_INVALID'
2474: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2475: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2476: , p_Token_Tbl => l_Token_Tbl );

Line 2485: Error_Handler.Add_Error_Token(

2481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2482:
2483: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2484: THEN
2485: Error_Handler.Add_Error_Token(
2486: p_Message_Text => l_err_text
2487: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2488: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl );
2489: END IF;

Line 2519: Error_Handler.Add_Error_Token

2515: l_token_tbl(2).token_value := p_ECO_rec.ECO_name;
2516: l_token_tbl(1).token_name := 'REQUESTOR';
2517: l_token_tbl(1).token_value := p_ECO_rec.Requestor;
2518:
2519: Error_Handler.Add_Error_Token
2520: ( p_Message_Name => 'ENG_REQUESTOR_INVALID'
2521: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2522: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2523: , p_Token_Tbl => l_Token_Tbl

Line 2533: Error_Handler.Add_Error_Token

2529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2530:
2531: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2532: THEN
2533: Error_Handler.Add_Error_Token
2534: ( p_Message_Text => l_err_text
2535: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2536: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2537: );

Line 2567: Error_Handler.Add_Error_Token

2563: l_token_tbl(2).token_value := p_ECO_rec.ECO_name;
2564: l_token_tbl(1).token_name := 'PROJECT_NUMBER';
2565: l_token_tbl(1).token_value := p_ECO_rec.project_name;
2566:
2567: Error_Handler.Add_Error_Token
2568: ( p_Message_Name => 'ENG_PROJECT_INVALID'
2569: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2570: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2571: , p_Token_Tbl => l_Token_Tbl

Line 2581: Error_Handler.Add_Error_Token

2577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2578:
2579: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2580: THEN
2581: Error_Handler.Add_Error_Token
2582: ( p_Message_Text => l_err_text
2583: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2584: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2585: );

Line 2616: Error_Handler.Add_Error_Token

2612: l_token_tbl(2).token_value := p_ECO_rec.ECO_name;
2613: l_token_tbl(1).token_name := 'TASK_NUMBER';
2614: l_token_tbl(1).token_value := p_ECO_rec.task_number;
2615:
2616: Error_Handler.Add_Error_Token
2617: ( p_Message_Name => 'ENG_TASK_INVALID'
2618: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2619: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2620: , p_Token_Tbl => l_Token_Tbl

Line 2630: Error_Handler.Add_Error_Token

2626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2627:
2628: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2629: THEN
2630: Error_Handler.Add_Error_Token
2631: ( p_Message_Text => l_err_text
2632: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2633: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2634: );

Line 2672: Error_Handler.Add_Error_Token

2668: l_token_tbl(1).token_value := p_ECO_rec.Assignee ;
2669: --l_token_tbl(3).token_name := 'COMPANY_NAME';
2670: --l_token_tbl(3).token_value := p_ECO_rec.Assignee_Company_Name ;
2671:
2672: Error_Handler.Add_Error_Token
2673: ( p_Message_Name => 'ENG_ASSIGNEE_INVALID'
2674: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2675: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2676: , p_Token_Tbl => l_Token_Tbl

Line 2688: Error_Handler.Add_Error_Token

2684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2685:
2686: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2687: THEN
2688: Error_Handler.Add_Error_Token
2689: ( p_Message_Text => l_err_text
2690: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2691: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2692: );

Line 2729: Error_Handler.Add_Error_Token

2725: THEN
2726: l_token_tbl(1).token_name := 'CHANGE_MANAGEMENT_TYPE';
2727: l_token_tbl(1).token_value := p_ECO_rec.Change_Management_Type;
2728:
2729: Error_Handler.Add_Error_Token
2730: ( p_message_name => 'ENG_CHG_MGMT_TYPE_INVALID'
2731: , p_mesg_token_tbl => l_mesg_token_tbl
2732: , p_token_tbl => g_token_tbl
2733: , x_mesg_token_tbl => l_mesg_token_tbl

Line 2746: Error_Handler.Add_Error_Token

2742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2743:
2744: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2745: THEN
2746: Error_Handler.Add_Error_Token
2747: ( p_Message_Text => l_err_text
2748: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2749: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2750: );

Line 2784: Error_Handler.Add_Error_Token

2780: THEN
2781: l_token_tbl(1).token_name := 'STATUS_TYPE';
2782: l_token_tbl(1).token_value := p_ECO_rec.Status_Name;
2783:
2784: Error_Handler.Add_Error_Token
2785: ( p_message_name => 'ENG_STATUS_TYPE_INVALID'
2786: , p_mesg_token_tbl => l_mesg_token_tbl
2787: , p_token_tbl => g_token_tbl
2788: , x_mesg_token_tbl => l_mesg_token_tbl

Line 2815: Error_Handler.Add_Error_Token

2811: THEN
2812: l_token_tbl(1).token_name := 'APPROVAL_STATUS_TYPE';
2813: l_token_tbl(1).token_value := p_ECO_rec.Approval_Status_Name;
2814:
2815: Error_Handler.Add_Error_Token
2816: ( p_message_name => 'ENG_APPR_STATUS_TYPE_INVALID'
2817: , p_mesg_token_tbl => l_mesg_token_tbl
2818: , p_token_tbl => g_token_tbl
2819: , x_mesg_token_tbl => l_mesg_token_tbl

Line 2851: Error_Handler.Add_Error_Token

2847: THEN
2848: l_token_tbl(1).token_name := 'SOURCE_TYPE';
2849: l_token_tbl(1).token_value := p_ECO_rec.Source_Type ;
2850:
2851: Error_Handler.Add_Error_Token
2852: ( p_message_name => 'ENG_CHG_SRC_TYPE_INVALID'
2853: , p_mesg_token_tbl => l_mesg_token_tbl
2854: , p_token_tbl => g_token_tbl
2855: , x_mesg_token_tbl => l_mesg_token_tbl

Line 2868: Error_Handler.Add_Error_Token

2864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2865:
2866: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2867: THEN
2868: Error_Handler.Add_Error_Token
2869: ( p_Message_Text => l_err_text
2870: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2871: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2872: );

Line 2911: Error_Handler.Add_Error_Token

2907: l_token_tbl(1).token_value := p_ECO_rec.Source_Type ;
2908: l_token_tbl(2).token_name := 'SOURCE_NAME';
2909: l_token_tbl(2).token_value := p_ECO_rec.Source_Name ;
2910:
2911: Error_Handler.Add_Error_Token
2912: ( p_message_name => 'ENG_CHG_SRC_NAME_INVALID'
2913: , p_mesg_token_tbl => l_mesg_token_tbl
2914: , p_token_tbl => g_token_tbl
2915: , x_mesg_token_tbl => l_mesg_token_tbl

Line 2928: Error_Handler.Add_Error_Token

2924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2925:
2926: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2927: THEN
2928: Error_Handler.Add_Error_Token
2929: ( p_Message_Text => l_err_text
2930: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2931: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2932: );

Line 2963: Error_Handler.Add_Error_Token

2959: l_token_tbl(2).token_value := p_ECO_rec.ECO_name;
2960: l_token_tbl(1).token_name := 'ORGANIZATION_HIERARCHY';
2961: l_token_tbl(1).token_value := p_ECO_rec.Organization_Hierarchy;
2962:
2963: Error_Handler.Add_Error_Token
2964: ( p_Message_Name => 'ENG_HIERARCHY_INVALID'
2965: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2966: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2967: , p_Token_Tbl => l_Token_Tbl

Line 2977: Error_Handler.Add_Error_Token

2973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2974:
2975: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2976: THEN
2977: Error_Handler.Add_Error_Token
2978: ( p_Message_Text => l_err_text
2979: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2980: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2981: );

Line 3017: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

3013: PROCEDURE ECO_Header_UUI_To_UI
3014: ( p_eco_rec IN Eng_Eco_Pub.Eco_Rec_Type
3015: , p_eco_unexp_rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
3016: , x_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
3017: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3018: , x_Return_Status OUT NOCOPY VARCHAR2
3019: )
3020: IS
3021:

Line 3049: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

3045: PROCEDURE ECO_Revision_UUI_To_UI
3046: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
3047: , p_eco_rev_unexp_rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
3048: , x_eco_rev_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
3049: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3050: , x_Return_Status OUT NOCOPY VARCHAR2
3051: )
3052: IS
3053: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 3053: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

3049: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3050: , x_Return_Status OUT NOCOPY VARCHAR2
3051: )
3052: IS
3053: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3054: l_dummy VARCHAR2(30);
3055:
3056: BEGIN
3057:

Line 3064: Error_Handler.Add_Error_Token

3060:
3061: IF p_eco_revision_rec.revision IS NULL OR
3062: p_eco_revision_rec.revision = FND_API.G_MISS_CHAR
3063: THEN
3064: Error_Handler.Add_Error_Token
3065: ( p_Message_Name => 'ENG_REVISION_KEYCOL_NULL'
3066: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3067: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3068: );

Line 3094: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

3090: PROCEDURE Revised_Item_UUI_To_UI
3091: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
3092: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
3093: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
3094: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3095: , x_Return_Status OUT NOCOPY VARCHAR2
3096: )
3097: IS
3098: l_err_text VARCHAR2(2000);

Line 3100: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

3096: )
3097: IS
3098: l_err_text VARCHAR2(2000);
3099: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
3100: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3101: l_return_status VARCHAR2(1);
3102: l_dummy VARCHAR2(30);
3103: BEGIN
3104:

Line 3119: Error_Handler.Add_Error_Token

3115: ************************************************************/
3116: IF p_revised_item_rec.revised_item_name IS NULL OR
3117: p_revised_item_rec.revised_item_name = FND_API.G_MISS_CHAR
3118: THEN
3119: Error_Handler.Add_Error_Token
3120: ( p_Message_Name => 'ENG_RITEM_NAME_KEYCOL_NULL'
3121: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3122: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3123: );

Line 3130: Error_Handler.Add_Error_Token

3126:
3127: IF p_revised_item_rec.start_effective_date IS NULL OR
3128: p_revised_item_rec.start_Effective_date = FND_API.G_MISS_DATE
3129: THEN
3130: Error_Handler.Add_Error_Token
3131: ( p_Message_Name => 'ENG_RITEM_DATE_KEYCOL_NULL'
3132: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3133: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3134: );

Line 3168: Error_Handler.Add_Error_Token

3164: THEN
3165: g_token_tbl(2).token_name := 'ORGANIZATION_CODE';
3166: g_token_tbl(2).token_value :=
3167: p_revised_item_rec.organization_code;
3168: Error_Handler.Add_Error_Token
3169: ( p_Message_Name => 'ENG_REVISED_ITEM_INVALID'
3170: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3171: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3172: , p_Token_Tbl => g_Token_Tbl

Line 3186: Error_Handler.Add_Error_Token

3182: THEN
3183: g_token_tbl(2).token_name := 'CHANGE_NOTICE';
3184: g_token_tbl(2).token_value :=
3185: p_revised_item_rec.eco_name;
3186: Error_Handler.Add_Error_Token
3187: ( p_Message_Name => 'ENG_REVISED_ITEM_INVALID'
3188: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3189: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3190: , p_Token_Tbl => g_Token_Tbl

Line 3483: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

3479: , p_transaction_type IN VARCHAR2 := NULL
3480: , x_revised_item_sequence_id OUT NOCOPY NUMBER
3481: , x_bill_sequence_id OUT NOCOPY NUMBER
3482: , x_component_sequence_id OUT NOCOPY NUMBER
3483: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3484: , x_other_message OUT NOCOPY VARCHAR2
3485: , x_other_token_tbl OUT NOCOPY Error_Handler.Token_Tbl_Type
3486: , x_return_status OUT NOCOPY VARCHAR2
3487: )

Line 3485: , x_other_token_tbl OUT NOCOPY Error_Handler.Token_Tbl_Type

3481: , x_bill_sequence_id OUT NOCOPY NUMBER
3482: , x_component_sequence_id OUT NOCOPY NUMBER
3483: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3484: , x_other_message OUT NOCOPY VARCHAR2
3485: , x_other_token_tbl OUT NOCOPY Error_Handler.Token_Tbl_Type
3486: , x_return_status OUT NOCOPY VARCHAR2
3487: )
3488: IS
3489: l_lot_number VARCHAR2(30) ;

Line 3497: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

3493: l_eco_for_production NUMBER ;
3494: l_cfm_routing_flag NUMBER ;
3495:
3496: l_err_text VARCHAR2(2000);
3497: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3498: l_return_status VARCHAR2(1);
3499: BEGIN
3500:
3501: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3532: Error_Handler.Add_Error_Token

3528: g_Token_Tbl(2).Token_Value := p_revised_item_name;
3529: g_token_tbl(3).token_name := 'ECO_NAME';
3530: g_token_tbl(3).token_value := p_change_notice ;
3531:
3532: Error_Handler.Add_Error_Token
3533: ( p_Message_Name => 'BOM_REV_SEQUENCE_NOT_FOUND'
3534: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3535: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3536: , p_Token_Tbl => g_Token_Tbl

Line 3546: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('And this call returned with ' || l_Return_Status); END IF ;

3542: x_other_message := 'BOM_CMP_UUI_SEV_ERROR';
3543: x_other_token_tbl(1).token_name := 'REVISED_COMPONENT_NAME';
3544: x_other_token_tbl(1).token_value := p_component_item_name ;
3545:
3546: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('And this call returned with ' || l_Return_Status); END IF ;
3547:
3548: RETURN;
3549:
3550: ELSIF p_transaction_type IN

Line 3561: Error_Handler.Add_Error_Token

3557:
3558: g_Token_Tbl(1).Token_Name := 'REVISED_ITEM_NAME';
3559: g_Token_Tbl(1).Token_Value := p_revised_item_name;
3560:
3561: Error_Handler.Add_Error_Token
3562: ( p_Message_Name => 'BOM_BILL_SEQUENCE_NOT_FOUND'
3563: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3564: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3565: , p_Token_Tbl => g_Token_Tbl

Line 3585: Error_Handler.Add_Error_Token

3581: g_Token_Tbl(2).Token_Value := p_rfd_sbc_name ;
3582: g_token_tbl(3).token_name := 'ECO_NAME';
3583: g_token_tbl(3).token_value := p_change_notice ;
3584:
3585: Error_Handler.Add_Error_Token
3586: ( p_Message_Name => 'BOM_SBC_REV_SEQ_NOT_FOUND'
3587: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3588: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3589: , p_Token_Tbl => g_Token_Tbl

Line 3615: Error_Handler.Add_Error_Token

3611: g_Token_Tbl(2).Token_Value := p_rfd_sbc_name ;
3612: g_Token_Tbl(3).Token_Name := 'ECO_NAME';
3613: g_Token_Tbl(3).Token_Value := p_change_notice ;
3614:
3615: Error_Handler.Add_Error_Token
3616: ( p_Message_Name => 'BOM_RFD_REV_SEQ_NOT_FOUND'
3617: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3618: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3619: , p_Token_Tbl => g_Token_Tbl

Line 3642: Error_Handler.Add_Error_Token

3638: g_Token_Tbl(1).Token_Value := p_revised_item_name ;
3639: g_Token_Tbl(2).Token_Name := 'REFERENCE_DESIGNATOR_NAME';
3640: g_Token_Tbl(2).Token_Value := p_rfd_sbc_name ;
3641:
3642: Error_Handler.Add_Error_Token
3643: ( p_Message_Name => 'BOM_RFD_BILL_SEQ_NOT_FOUND'
3644: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3645: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3646: , p_Token_Tbl => g_Token_Tbl

Line 3675: IF Bom_Globals.get_debug = 'Y' then Error_Handler.write_debug

3671: , p_bill_sequence_id => x_bill_sequence_id
3672: , x_err_text => l_Err_Text
3673: );
3674:
3675: IF Bom_Globals.get_debug = 'Y' then Error_Handler.write_debug
3676: ('Component sequence ' || x_component_sequence_id ) ;
3677: END IF;
3678:
3679: IF x_component_sequence_id IS NULL

Line 3689: Error_Handler.Add_Error_Token

3685: g_Token_Tbl(2).Token_Value := p_revised_item_name ;
3686: g_Token_Tbl(3).Token_Name := 'SUBSTITUTE_ITEM_NAME';
3687: g_Token_Tbl(3).Token_Value := p_rfd_sbc_name ;
3688:
3689: Error_Handler.Add_Error_Token
3690: ( p_Message_Name => 'BOM_SBC_COMP_SEQ_NOT_FOUND'
3691: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3692: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3693: , p_Token_Tbl => g_Token_Tbl

Line 3715: Error_Handler.Add_Error_Token

3711: g_Token_Tbl(2).Token_Value := p_rfd_sbc_name ;
3712: g_Token_Tbl(3).Token_Name := 'REVISED_COMPONENT_NAME';
3713: g_Token_Tbl(3).Token_Value := p_component_item_name ;
3714:
3715: Error_Handler.Add_Error_Token
3716: ( p_Message_Name => 'BOM_RFD_COMP_SEQ_NOT_FOUND'
3717: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3718: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3719: , p_Token_Tbl => g_Token_Tbl

Line 3780: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

3776: , p_alternate_routing_code IN VARCHAR2 := NULL -- Added for bug 13329115
3777: , x_revised_item_sequence_id OUT NOCOPY NUMBER
3778: , x_routing_sequence_id OUT NOCOPY NUMBER
3779: , x_operation_sequence_id OUT NOCOPY NUMBER
3780: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3781: , x_other_message OUT NOCOPY VARCHAR2
3782: , x_other_token_tbl OUT NOCOPY Error_Handler.Token_Tbl_Type
3783: , x_return_status OUT NOCOPY VARCHAR2
3784: )

Line 3782: , x_other_token_tbl OUT NOCOPY Error_Handler.Token_Tbl_Type

3778: , x_routing_sequence_id OUT NOCOPY NUMBER
3779: , x_operation_sequence_id OUT NOCOPY NUMBER
3780: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3781: , x_other_message OUT NOCOPY VARCHAR2
3782: , x_other_token_tbl OUT NOCOPY Error_Handler.Token_Tbl_Type
3783: , x_return_status OUT NOCOPY VARCHAR2
3784: )
3785: IS
3786: l_lot_number VARCHAR2(30) ;

Line 3793: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

3789: l_from_cum_qty NUMBER ;
3790: l_eco_for_production NUMBER ;
3791: l_cfm_routing_flag NUMBER ;
3792: l_err_text VARCHAR2(2000);
3793: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3794: l_return_status VARCHAR2(1);
3795: BEGIN
3796:
3797: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3827: Error_Handler.Add_Error_Token

3823: g_Token_Tbl(2).Token_Value := p_revised_item_name;
3824: g_token_tbl(3).token_name := 'ECO_NAME';
3825: g_token_tbl(3).token_value := p_change_notice ;
3826:
3827: Error_Handler.Add_Error_Token
3828: ( p_Message_Name => 'BOM_OP_RIT_SEQUENCE_NOT_FOUND'
3829: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3830: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3831: , p_Token_Tbl => g_Token_Tbl

Line 3851: Error_Handler.Add_Error_Token

3847: g_Token_Tbl(2).Token_Value := p_revised_item_name;
3848: g_token_tbl(3).token_name := 'ECO_NAME';
3849: g_token_tbl(3).token_value := p_change_notice ;
3850:
3851: Error_Handler.Add_Error_Token
3852: ( p_Message_Name => 'BOM_RES_RIT_SEQUENCE_NOT_FOUND'
3853: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3854: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3855: , p_Token_Tbl => g_Token_Tbl

Line 3875: Error_Handler.Add_Error_Token

3871: g_Token_Tbl(3).Token_Value := p_revised_item_name;
3872: g_token_tbl(4).token_name := 'ECO_NAME';
3873: g_token_tbl(4).token_value := p_change_notice ;
3874:
3875: Error_Handler.Add_Error_Token
3876: ( p_Message_Name => 'BOM_SUB_RES_RIT_SEQ_NOT_FOUND'
3877: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3878: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3879: , p_Token_Tbl => g_Token_Tbl

Line 3906: Error_Handler.Add_Error_Token

3902: IF x_operation_sequence_id IS NULL AND p_entity_processed = 'RES'
3903: THEN
3904: g_token_tbl(1).token_name := 'OP_SEQ_NUMBER';
3905: g_token_tbl(1).token_value := p_operation_sequence_number ;
3906: Error_Handler.Add_Error_Token
3907: ( p_Message_Name => 'BOM_RES_OP_NOT_FOUND'
3908: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3909: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3910: , p_Token_Tbl => g_Token_Tbl

Line 3919: Error_Handler.Add_Error_Token

3915: THEN
3916: g_token_tbl(1).token_name := 'OP_SEQ_NUMBER';
3917: g_token_tbl(1).token_value := p_operation_sequence_number ;
3918:
3919: Error_Handler.Add_Error_Token
3920: ( p_Message_Name => 'BOM_SUB_RES_OP_NOT_FOUND'
3921: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3922: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3923: , p_Token_Tbl => g_Token_Tbl

Line 3934: Error_Handler.Add_Error_Token

3930: x_operation_sequence_id = FND_API.G_MISS_NUM
3931: )
3932: THEN
3933: -- This is an unexpected error.
3934: Error_Handler.Add_Error_Token
3935: ( p_Message_Name => NULL
3936: , p_Message_Text => l_err_text || ' in ' ||
3937: G_PKG_NAME
3938: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3963: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

3959: PROCEDURE Change_Line_UUI_To_UI
3960: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
3961: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
3962: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
3963: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3964: , x_Return_Status OUT NOCOPY VARCHAR2
3965: )
3966: IS
3967:

Line 3970: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

3966: IS
3967:
3968: l_err_text VARCHAR2(2000);
3969: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;
3970: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3971: l_return_status VARCHAR2(1);
3972: BEGIN
3973:
3974: l_change_line_unexp_rec := p_change_line_unexp_rec;

Line 3989: Error_Handler.Add_Error_Token

3985: IF (p_change_line_rec.name IS NULL OR
3986: p_change_line_rec.name = FND_API.G_MISS_CHAR)
3987:
3988: THEN
3989: Error_Handler.Add_Error_Token
3990: ( p_Message_Name => 'ENG_CL_NAME_KEYCOL_NULL'
3991: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3992: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3993: );

Line 4027: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

4023: PROCEDURE Change_Line_VID
4024: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
4025: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
4026: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
4027: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
4028: , x_Return_Status OUT NOCOPY VARCHAR2
4029: )
4030: IS
4031:

Line 4034: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

4030: IS
4031:
4032: l_err_text VARCHAR2(2000) := NULL;
4033: l_Return_Status VARCHAR2(1);
4034: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
4035: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4036: l_change_mgmt_type_code VARCHAR2(30);
4037: l_hdr_change_mgmt_type_code VARCHAR2(30);
4038: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;

Line 4035: l_Token_Tbl Error_Handler.Token_Tbl_Type;

4031:
4032: l_err_text VARCHAR2(2000) := NULL;
4033: l_Return_Status VARCHAR2(1);
4034: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
4035: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4036: l_change_mgmt_type_code VARCHAR2(30);
4037: l_hdr_change_mgmt_type_code VARCHAR2(30);
4038: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;
4039: l_dynamic_sql VARCHAR2(4000);

Line 4114: Error_Handler.Add_Error_Token

4110: l_token_tbl(2).token_value := p_change_line_rec.change_management_type;
4111:
4112: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4113: THEN
4114: Error_Handler.Add_Error_Token
4115: (
4116: p_Message_Name => 'ENG_CHANGE_MGMT_TYPE_INVALID'
4117: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4118: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 4158: Error_Handler.Add_Error_Token

4154: l_token_tbl(2).token_value := p_change_line_rec.change_type_code;
4155:
4156: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4157: THEN
4158: Error_Handler.Add_Error_Token
4159: ( p_Message_Name => 'ENG_CL_CHANGE_TYPE_INVALID'
4160: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4161: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4162: , p_Token_Tbl => l_Token_Tbl

Line 4173: Error_Handler.Add_Error_Token

4169: ELSIF l_change_type_id = FND_API.G_MISS_NUM
4170: THEN
4171: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4172: THEN
4173: Error_Handler.Add_Error_Token
4174: ( p_Message_Text => l_err_text
4175: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4176: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4177: );

Line 4198: Error_Handler.Add_Error_Token

4194: THEN
4195: l_token_tbl(2).token_name := 'CHANGE_TYPE_CODE';
4196: l_token_tbl(2).token_value := p_change_line_rec.change_type_code ;
4197:
4198: Error_Handler.Add_Error_Token
4199: ( p_Message_Name => 'ENG_CL_CHANGE_TYPE_DISABLED'
4200: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4201: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4202: , p_Token_Tbl => l_Token_Tbl

Line 4263: error_handler.add_error_token (

4259: ELSE
4260: l_token_tbl (1).token_name := 'CHANGE_LINE_TYPE';
4261: l_token_tbl (1).token_value :=
4262: p_change_line_rec.change_type_code;
4263: error_handler.add_error_token (
4264: p_message_name=> 'ENG_PK1_NAME_INVALID',
4265: p_mesg_token_tbl=> l_mesg_token_tbl,
4266: x_mesg_token_tbl=> l_mesg_token_tbl,
4267: p_token_tbl=> l_token_tbl

Line 4275: error_handler.add_error_token (

4271: ELSE
4272: l_token_tbl (1).token_name := 'CHANGE_LINE_TYPE';
4273: l_token_tbl (1).token_value :=
4274: p_change_line_rec.change_type_code;
4275: error_handler.add_error_token (
4276: p_message_name=> 'ENG_PK3_NAME_INVALID',
4277: p_mesg_token_tbl=> l_mesg_token_tbl,
4278: x_mesg_token_tbl=> l_mesg_token_tbl,
4279: p_token_tbl=> l_token_tbl

Line 4287: error_handler.add_error_token (

4283: ELSE
4284: l_token_tbl (1).token_name := 'CHANGE_LINE_TYPE';
4285: l_token_tbl (1).token_value :=
4286: p_change_line_rec.change_type_code;
4287: error_handler.add_error_token (
4288: p_message_name=> 'ENG_PK4_NAME_INVALID',
4289: p_mesg_token_tbl=> l_mesg_token_tbl,
4290: x_mesg_token_tbl=> l_mesg_token_tbl,
4291: p_token_tbl=> l_token_tbl

Line 4303: error_handler.add_error_token (

4299: THEN
4300: l_token_tbl (1).token_name := 'CHANGE_LINE_TYPE';
4301: l_token_tbl (1).token_value :=
4302: p_change_line_rec.change_type_code;
4303: error_handler.add_error_token (
4304: p_message_name=> 'ENG_PK1_NAME_INVALID',
4305: p_mesg_token_tbl=> l_mesg_token_tbl,
4306: x_mesg_token_tbl=> l_mesg_token_tbl,
4307: p_token_tbl=> l_token_tbl

Line 4319: error_handler.add_error_token (

4315: THEN
4316: l_token_tbl (1).token_name := 'CHANGE_LINE_TYPE';
4317: l_token_tbl (1).token_value :=
4318: p_change_line_rec.change_type_code;
4319: error_handler.add_error_token (
4320: p_message_name=> 'ENG_PK3_NAME_INVALID',
4321: p_mesg_token_tbl=> l_mesg_token_tbl,
4322: x_mesg_token_tbl=> l_mesg_token_tbl,
4323: p_token_tbl=> l_token_tbl

Line 4335: error_handler.add_error_token (

4331: THEN
4332: l_token_tbl (1).token_name := 'CHANGE_LINE_TYPE';
4333: l_token_tbl (1).token_value :=
4334: p_change_line_rec.change_type_code;
4335: error_handler.add_error_token (
4336: p_message_name=> 'ENG_PK4_NAME_INVALID',
4337: p_mesg_token_tbl=> l_mesg_token_tbl,
4338: x_mesg_token_tbl=> l_mesg_token_tbl,
4339: p_token_tbl=> l_token_tbl

Line 4370: error_handler.add_error_token (

4366: ELSE
4367: l_token_tbl (1).token_name := 'CHANGE_LINE_TYPE';
4368: l_token_tbl (1).token_value :=
4369: p_change_line_rec.change_type_code;
4370: error_handler.add_error_token (
4371: p_message_name=> 'ENG_PK1_NAME_INVALID',
4372: p_mesg_token_tbl=> l_mesg_token_tbl,
4373: x_mesg_token_tbl=> l_mesg_token_tbl,
4374: p_token_tbl=> l_token_tbl

Line 4382: error_handler.add_error_token (

4378: ELSE
4379: l_token_tbl (1).token_name := 'CHANGE_LINE_TYPE';
4380: l_token_tbl (1).token_value :=
4381: p_change_line_rec.change_type_code;
4382: error_handler.add_error_token (
4383: p_message_name=> 'ENG_PK3_NAME_INVALID',
4384: p_mesg_token_tbl=> l_mesg_token_tbl,
4385: x_mesg_token_tbl=> l_mesg_token_tbl,
4386: p_token_tbl=> l_token_tbl

Line 4398: error_handler.add_error_token (

4394: THEN
4395: l_token_tbl (1).token_name := 'CHANGE_LINE_TYPE';
4396: l_token_tbl (1).token_value :=
4397: p_change_line_rec.change_type_code;
4398: error_handler.add_error_token (
4399: p_message_name=> 'ENG_PK1_NAME_INVALID',
4400: p_mesg_token_tbl=> l_mesg_token_tbl,
4401: x_mesg_token_tbl=> l_mesg_token_tbl,
4402: p_token_tbl=> l_token_tbl

Line 4414: error_handler.add_error_token (

4410: THEN
4411: l_token_tbl (1).token_name := 'CHANGE_LINE_TYPE';
4412: l_token_tbl (1).token_value :=
4413: p_change_line_rec.change_type_code;
4414: error_handler.add_error_token (
4415: p_message_name=> 'ENG_PK3_NAME_INVALID',
4416: p_mesg_token_tbl=> l_mesg_token_tbl,
4417: x_mesg_token_tbl=> l_mesg_token_tbl,
4418: p_token_tbl=> l_token_tbl

Line 4460: Error_Handler.Add_Error_Token

4456: THEN
4457: l_token_tbl(2).token_name := 'ASSIGNEE';
4458: l_token_tbl(2).token_value := p_change_line_rec.Assignee_Name;
4459:
4460: Error_Handler.Add_Error_Token
4461: ( p_Message_Name => 'ENG_ASSIGNEE_INVALID'
4462: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4463: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4464: , p_Token_Tbl => l_Token_Tbl

Line 4476: Error_Handler.Add_Error_Token

4472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4473:
4474: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4475: THEN
4476: Error_Handler.Add_Error_Token
4477: ( p_Message_Text => l_err_text
4478: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4479: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4480: );

Line 4654: Error_Handler.Add_Error_Token

4650: l_token_tbl(2).token_value := p_change_line_rec.pk1_name ;
4651:
4652: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4653: THEN
4654: Error_Handler.Add_Error_Token
4655: ( p_Message_Name => 'ENG_PK_VALUES_INVALID'
4656: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4657: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4658: , p_Token_Tbl => l_Token_Tbl