[Home] [Help]
1230: SELECT meaning
1231: INTO l_user_activity_name
1232: FROM oe_lookups
1233: WHERE lookup_type = DECODE(p_item_type,
1234: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
1235: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
1236: AND lookup_code = p_activity_name;
1237:
1238: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_ALL_LINES');
1231: INTO l_user_activity_name
1232: FROM oe_lookups
1233: WHERE lookup_type = DECODE(p_item_type,
1234: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
1235: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
1236: AND lookup_code = p_activity_name;
1237:
1238: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_ALL_LINES');
1239: FND_MESSAGE.SET_TOKEN('WF_ACT', l_user_activity_name);
1268: SELECT meaning
1269: INTO l_user_activity_name
1270: FROM oe_lookups
1271: WHERE lookup_type = DECODE(p_item_type,
1272: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
1273: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
1274: AND lookup_code = p_activity_name;
1275:
1276: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_FEW_LINES');
1269: INTO l_user_activity_name
1270: FROM oe_lookups
1271: WHERE lookup_type = DECODE(p_item_type,
1272: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
1273: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
1274: AND lookup_code = p_activity_name;
1275:
1276: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_FEW_LINES');
1277: FND_MESSAGE.SET_TOKEN('WF_ACT', l_user_activity_name);
1530: SELECT meaning
1531: INTO l_user_activity_name
1532: FROM oe_lookups
1533: WHERE lookup_type = DECODE(p_item_type,
1534: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
1535: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
1536: AND lookup_code = p_activity_name;
1537:
1538: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_ALL_LINES');
1531: INTO l_user_activity_name
1532: FROM oe_lookups
1533: WHERE lookup_type = DECODE(p_item_type,
1534: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
1535: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
1536: AND lookup_code = p_activity_name;
1537:
1538: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_ALL_LINES');
1539: FND_MESSAGE.SET_TOKEN('WF_ACT',l_user_activity_name);
1568: SELECT meaning
1569: INTO l_user_activity_name
1570: FROM oe_lookups
1571: WHERE lookup_type = DECODE(p_item_type,
1572: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
1573: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
1574: AND lookup_code = p_activity_name;
1575:
1576: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_FEW_LINES');
1569: INTO l_user_activity_name
1570: FROM oe_lookups
1571: WHERE lookup_type = DECODE(p_item_type,
1572: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
1573: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
1574: AND lookup_code = p_activity_name;
1575:
1576: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_FEW_LINES');
1577: FND_MESSAGE.SET_TOKEN('WF_ACT',l_user_activity_name);
5983: OE_DEBUG_PUB.Add('IN Apply Holds..Orders',1);
5984:
5985: -- 8477694
5986:
5987: IF NOT OE_GLOBALS.G_SYS_HOLD THEN
5988: IF check_system_holds(
5989: p_hold_id => p_hold_id,
5990: x_return_status => x_return_status,
5991: x_msg_count => x_msg_count,
6179: IF l_wf_item_type is not null and l_wf_activity_name is not null THEN
6180: select meaning into l_user_activity_name
6181: from oe_lookups
6182: where lookup_type = DECODE(l_wf_item_type,
6183: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
6184: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
6185: and lookup_code = l_wf_activity_name;
6186:
6187: IF p_order_tbl.COUNT = 1 AND l_count_of_holds_applied = 0 THEN
6180: select meaning into l_user_activity_name
6181: from oe_lookups
6182: where lookup_type = DECODE(l_wf_item_type,
6183: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
6184: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
6185: and lookup_code = l_wf_activity_name;
6186:
6187: IF p_order_tbl.COUNT = 1 AND l_count_of_holds_applied = 0 THEN
6188: fnd_message.set_name('ONT', 'OE_NO_HOLD_FOR_ACTIVITY');
6337: BEGIN
6338: x_return_status := FND_API.G_RET_STS_SUCCESS;
6339:
6340: --8477694
6341: IF NOT OE_GLOBALS.G_SYS_HOLD THEN
6342: IF check_system_holds( p_hold_id => p_hold_source_rec.hold_id
6343: ,x_return_status => x_return_status
6344: ,x_msg_count => x_msg_count
6345: ,x_msg_data => x_msg_data
6491: x_return_status := FND_API.G_RET_STS_SUCCESS;
6492: oe_debug_pub.add('In Release Holds..Orders',1);
6493:
6494: --8477694
6495: IF NOT OE_GLOBALS.G_SYS_HOLD THEN
6496: IF check_system_holds( p_hold_id => p_hold_id
6497: ,x_return_status => x_return_status
6498: ,x_msg_count => x_msg_count
6499: ,x_msg_data => x_msg_data
6682: 8477694 */
6683:
6684: procedure process_apply_holds_lines (
6685: p_num_of_records IN NUMBER
6686: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
6687: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
6688: , p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE
6689: , p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE
6690: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6859: IF l_item_type IS NOT NULL AND l_activity_name IS NOT NULL THEN
6860: select meaning into l_user_activity_name
6861: from oe_lookups
6862: where lookup_type = DECODE(l_item_type,
6863: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
6864: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES',
6865: '-XX')
6866: and lookup_code = l_activity_name;
6867:
6860: select meaning into l_user_activity_name
6861: from oe_lookups
6862: where lookup_type = DECODE(l_item_type,
6863: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
6864: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES',
6865: '-XX')
6866: and lookup_code = l_activity_name;
6867:
6868: IF p_sel_rec_tbl.COUNT = 1 AND l_count_of_holds_applied = 0
6936:
6937: /*=================================*/
6938: procedure process_apply_holds_orders (
6939: p_num_of_records IN NUMBER
6940: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
6941: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
6942: , p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE
6943: , p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE
6944: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7093: IF l_item_type IS NOT NULL AND l_activity_name IS NOT NULL THEN
7094: select meaning into l_user_activity_name
7095: from oe_lookups
7096: where lookup_type = DECODE(l_item_type,
7097: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
7098: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES',
7099: '-XX')
7100: and lookup_code = l_activity_name;
7101:
7094: select meaning into l_user_activity_name
7095: from oe_lookups
7096: where lookup_type = DECODE(l_item_type,
7097: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
7098: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES',
7099: '-XX')
7100: and lookup_code = l_activity_name;
7101:
7102: IF p_sel_rec_tbl.COUNT = 1 AND l_count_of_holds_applied = 0
7177: -- called after ER 1373910
7178:
7179: procedure process_release_holds_lines (
7180: p_num_of_records IN NUMBER
7181: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
7182: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
7183: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
7184: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
7185: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7354: PROCESS_RELEASE_HOLDS_ORDERS
7355: */
7356: procedure process_release_holds_orders (
7357: p_num_of_records IN NUMBER
7358: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
7359: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
7360: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
7361: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
7362: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7959: */
7960:
7961: procedure process_release_holds_lines (
7962: p_num_of_records IN NUMBER
7963: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
7964: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
7965: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
7966: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
7967: , p_wf_release_action IN VARCHAR2
8169: */
8170:
8171: procedure process_release_holds_orders (
8172: p_num_of_records IN NUMBER
8173: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
8174: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
8175: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
8176: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
8177: , p_wf_release_action IN VARCHAR2
8600: BEGIN
8601: x_return_status := FND_API.G_RET_STS_SUCCESS;
8602:
8603: l_user_id := OE_HOLDS_PVT.get_user_id;
8604: l_org_id := OE_GLOBALS.G_ORG_ID;
8605: if l_org_id IS NULL THEN
8606: OE_GLOBALS.Set_Context;
8607: l_org_id := OE_GLOBALS.G_ORG_ID;
8608: end if;
8602:
8603: l_user_id := OE_HOLDS_PVT.get_user_id;
8604: l_org_id := OE_GLOBALS.G_ORG_ID;
8605: if l_org_id IS NULL THEN
8606: OE_GLOBALS.Set_Context;
8607: l_org_id := OE_GLOBALS.G_ORG_ID;
8608: end if;
8609:
8610: for c_rec IN c_order_holds
8603: l_user_id := OE_HOLDS_PVT.get_user_id;
8604: l_org_id := OE_GLOBALS.G_ORG_ID;
8605: if l_org_id IS NULL THEN
8606: OE_GLOBALS.Set_Context;
8607: l_org_id := OE_GLOBALS.G_ORG_ID;
8608: end if;
8609:
8610: for c_rec IN c_order_holds
8611: loop
8741: x_return_status := FND_API.G_RET_STS_SUCCESS;
8742:
8743: -- 8477694
8744:
8745: IF NOT OE_GLOBALS.G_SYS_HOLD THEN
8746: IF check_system_holds(
8747: p_hold_id => p_hold_source_rec.hold_id,
8748: x_return_status => x_return_status,
8749: x_msg_count => x_msg_count,
9236:
9237: select meaning into l_user_activity_name
9238: from oe_lookups
9239: where lookup_type = DECODE(p_item_type,
9240: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9241: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9242: and lookup_code = p_activity_name;
9243:
9244: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9237: select meaning into l_user_activity_name
9238: from oe_lookups
9239: where lookup_type = DECODE(p_item_type,
9240: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9241: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9242: and lookup_code = p_activity_name;
9243:
9244: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9245: fnd_message.set_token('WF_ACT', l_user_activity_name);
9269:
9270: select meaning into l_user_activity_name
9271: from oe_lookups
9272: where lookup_type = DECODE(p_item_type,
9273: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9274: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9275: and lookup_code = p_activity_name;
9276:
9277: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9270: select meaning into l_user_activity_name
9271: from oe_lookups
9272: where lookup_type = DECODE(p_item_type,
9273: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9274: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9275: and lookup_code = p_activity_name;
9276:
9277: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9278: fnd_message.set_token('WF_ACT', l_user_activity_name);
9558:
9559: select meaning into l_user_activity_name
9560: from oe_lookups
9561: where lookup_type = DECODE(p_item_type,
9562: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9563: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9564: and lookup_code = p_activity_name;
9565:
9566: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9559: select meaning into l_user_activity_name
9560: from oe_lookups
9561: where lookup_type = DECODE(p_item_type,
9562: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9563: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9564: and lookup_code = p_activity_name;
9565:
9566: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9567: fnd_message.set_token('WF_ACT', l_user_activity_name);
9593:
9594: select meaning into l_user_activity_name
9595: from oe_lookups
9596: where lookup_type = DECODE(p_item_type,
9597: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9598: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9599: and lookup_code = p_activity_name;
9600:
9601: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9594: select meaning into l_user_activity_name
9595: from oe_lookups
9596: where lookup_type = DECODE(p_item_type,
9597: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9598: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9599: and lookup_code = p_activity_name;
9600:
9601: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9602: fnd_message.set_token('WF_ACT', l_user_activity_name);
9775:
9776: select meaning into l_user_activity_name
9777: from oe_lookups
9778: where lookup_type = DECODE(p_item_type,
9779: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9780: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9781: and lookup_code = p_activity_name;
9782:
9783: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9776: select meaning into l_user_activity_name
9777: from oe_lookups
9778: where lookup_type = DECODE(p_item_type,
9779: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9780: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9781: and lookup_code = p_activity_name;
9782:
9783: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9784: fnd_message.set_token('WF_ACT', l_user_activity_name);
9808:
9809: select meaning into l_user_activity_name
9810: from oe_lookups
9811: where lookup_type = DECODE(p_item_type,
9812: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9813: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9814: and lookup_code = p_activity_name;
9815:
9816: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9809: select meaning into l_user_activity_name
9810: from oe_lookups
9811: where lookup_type = DECODE(p_item_type,
9812: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9813: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9814: and lookup_code = p_activity_name;
9815:
9816: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9817: fnd_message.set_token('WF_ACT', l_user_activity_name);
9988:
9989: select meaning into l_user_activity_name
9990: from oe_lookups
9991: where lookup_type = DECODE(p_item_type,
9992: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9993: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9994: and lookup_code = p_activity_name;
9995:
9996: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9989: select meaning into l_user_activity_name
9990: from oe_lookups
9991: where lookup_type = DECODE(p_item_type,
9992: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9993: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9994: and lookup_code = p_activity_name;
9995:
9996: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9997: fnd_message.set_token('WF_ACT', l_user_activity_name);
10020:
10021: select meaning into l_user_activity_name
10022: from oe_lookups
10023: where lookup_type = DECODE(p_item_type,
10024: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10025: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10026: and lookup_code = p_activity_name;
10027:
10028: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10021: select meaning into l_user_activity_name
10022: from oe_lookups
10023: where lookup_type = DECODE(p_item_type,
10024: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10025: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10026: and lookup_code = p_activity_name;
10027:
10028: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10029: fnd_message.set_token('WF_ACT', l_user_activity_name);
10202:
10203: select meaning into l_user_activity_name
10204: from oe_lookups
10205: where lookup_type = DECODE(p_item_type,
10206: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10207: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10208: and lookup_code = p_activity_name;
10209:
10210: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10203: select meaning into l_user_activity_name
10204: from oe_lookups
10205: where lookup_type = DECODE(p_item_type,
10206: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10207: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10208: and lookup_code = p_activity_name;
10209:
10210: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10211: fnd_message.set_token('WF_ACT', l_user_activity_name);
10235:
10236: select meaning into l_user_activity_name
10237: from oe_lookups
10238: where lookup_type = DECODE(p_item_type,
10239: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10240: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10241: and lookup_code = p_activity_name;
10242:
10243: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10236: select meaning into l_user_activity_name
10237: from oe_lookups
10238: where lookup_type = DECODE(p_item_type,
10239: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10240: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10241: and lookup_code = p_activity_name;
10242:
10243: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10244: fnd_message.set_token('WF_ACT', l_user_activity_name);
10437:
10438: select meaning into l_user_activity_name
10439: from oe_lookups
10440: where lookup_type = DECODE(p_item_type,
10441: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10442: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10443: and lookup_code = p_activity_name;
10444:
10445: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10438: select meaning into l_user_activity_name
10439: from oe_lookups
10440: where lookup_type = DECODE(p_item_type,
10441: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10442: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10443: and lookup_code = p_activity_name;
10444:
10445: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10446: fnd_message.set_token('WF_ACT', l_user_activity_name);
10470:
10471: select meaning into l_user_activity_name
10472: from oe_lookups
10473: where lookup_type = DECODE(p_item_type,
10474: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10475: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10476: and lookup_code = p_activity_name;
10477:
10478: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10471: select meaning into l_user_activity_name
10472: from oe_lookups
10473: where lookup_type = DECODE(p_item_type,
10474: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10475: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10476: and lookup_code = p_activity_name;
10477:
10478: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10479: fnd_message.set_token('WF_ACT', l_user_activity_name);
10950:
10951: select meaning into l_user_activity_name
10952: from oe_lookups
10953: where lookup_type = DECODE(p_item_type,
10954: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10955: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10956: and lookup_code = p_activity_name;
10957:
10958: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10951: select meaning into l_user_activity_name
10952: from oe_lookups
10953: where lookup_type = DECODE(p_item_type,
10954: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10955: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10956: and lookup_code = p_activity_name;
10957:
10958: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10959: fnd_message.set_token('WF_ACT', l_user_activity_name);
10983:
10984: select meaning into l_user_activity_name
10985: from oe_lookups
10986: where lookup_type = DECODE(p_item_type,
10987: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10988: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10989: and lookup_code = p_activity_name;
10990:
10991: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10984: select meaning into l_user_activity_name
10985: from oe_lookups
10986: where lookup_type = DECODE(p_item_type,
10987: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10988: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10989: and lookup_code = p_activity_name;
10990:
10991: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10992: fnd_message.set_token('WF_ACT', l_user_activity_name);
11255:
11256: select meaning into l_user_activity_name
11257: from oe_lookups
11258: where lookup_type = DECODE(p_item_type,
11259: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11260: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11261: and lookup_code = p_activity_name;
11262:
11263: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11256: select meaning into l_user_activity_name
11257: from oe_lookups
11258: where lookup_type = DECODE(p_item_type,
11259: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11260: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11261: and lookup_code = p_activity_name;
11262:
11263: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11264: fnd_message.set_token('WF_ACT', l_user_activity_name);
11288:
11289: select meaning into l_user_activity_name
11290: from oe_lookups
11291: where lookup_type = DECODE(p_item_type,
11292: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11293: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11294: and lookup_code = p_activity_name;
11295:
11296: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11289: select meaning into l_user_activity_name
11290: from oe_lookups
11291: where lookup_type = DECODE(p_item_type,
11292: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11293: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11294: and lookup_code = p_activity_name;
11295:
11296: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11297: fnd_message.set_token('WF_ACT', l_user_activity_name);
11469:
11470: select meaning into l_user_activity_name
11471: from oe_lookups
11472: where lookup_type = DECODE(p_item_type,
11473: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11474: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11475: and lookup_code = p_activity_name;
11476:
11477: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11470: select meaning into l_user_activity_name
11471: from oe_lookups
11472: where lookup_type = DECODE(p_item_type,
11473: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11474: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11475: and lookup_code = p_activity_name;
11476:
11477: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11478: fnd_message.set_token('WF_ACT', l_user_activity_name);
11502:
11503: select meaning into l_user_activity_name
11504: from oe_lookups
11505: where lookup_type = DECODE(p_item_type,
11506: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11507: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11508: and lookup_code = p_activity_name;
11509:
11510: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11503: select meaning into l_user_activity_name
11504: from oe_lookups
11505: where lookup_type = DECODE(p_item_type,
11506: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11507: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11508: and lookup_code = p_activity_name;
11509:
11510: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11511: fnd_message.set_token('WF_ACT', l_user_activity_name);
11686:
11687: select meaning into l_user_activity_name
11688: from oe_lookups
11689: where lookup_type = DECODE(p_item_type,
11690: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11691: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11692: and lookup_code = p_activity_name;
11693:
11694: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11687: select meaning into l_user_activity_name
11688: from oe_lookups
11689: where lookup_type = DECODE(p_item_type,
11690: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11691: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11692: and lookup_code = p_activity_name;
11693:
11694: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11695: fnd_message.set_token('WF_ACT', l_user_activity_name);
11719:
11720: select meaning into l_user_activity_name
11721: from oe_lookups
11722: where lookup_type = DECODE(p_item_type,
11723: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11724: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11725: and lookup_code = p_activity_name;
11726:
11727: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11720: select meaning into l_user_activity_name
11721: from oe_lookups
11722: where lookup_type = DECODE(p_item_type,
11723: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11724: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11725: and lookup_code = p_activity_name;
11726:
11727: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11728: fnd_message.set_token('WF_ACT', l_user_activity_name);
12011:
12012: select meaning into l_user_activity_name
12013: from oe_lookups
12014: where lookup_type = DECODE(p_item_type,
12015: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12016: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12017: and lookup_code = p_activity_name;
12018:
12019: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12012: select meaning into l_user_activity_name
12013: from oe_lookups
12014: where lookup_type = DECODE(p_item_type,
12015: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12016: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12017: and lookup_code = p_activity_name;
12018:
12019: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12020: fnd_message.set_token('WF_ACT', l_user_activity_name);
12044:
12045: select meaning into l_user_activity_name
12046: from oe_lookups
12047: where lookup_type = DECODE(p_item_type,
12048: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12049: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12050: and lookup_code = p_activity_name;
12051:
12052: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12045: select meaning into l_user_activity_name
12046: from oe_lookups
12047: where lookup_type = DECODE(p_item_type,
12048: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12049: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12050: and lookup_code = p_activity_name;
12051:
12052: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12053: fnd_message.set_token('WF_ACT', l_user_activity_name);
12225:
12226: select meaning into l_user_activity_name
12227: from oe_lookups
12228: where lookup_type = DECODE(p_item_type,
12229: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12230: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12231: and lookup_code = p_activity_name;
12232:
12233: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12226: select meaning into l_user_activity_name
12227: from oe_lookups
12228: where lookup_type = DECODE(p_item_type,
12229: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12230: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12231: and lookup_code = p_activity_name;
12232:
12233: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12234: fnd_message.set_token('WF_ACT', l_user_activity_name);
12258:
12259: select meaning into l_user_activity_name
12260: from oe_lookups
12261: where lookup_type = DECODE(p_item_type,
12262: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12263: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12264: and lookup_code = p_activity_name;
12265:
12266: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12259: select meaning into l_user_activity_name
12260: from oe_lookups
12261: where lookup_type = DECODE(p_item_type,
12262: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12263: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12264: and lookup_code = p_activity_name;
12265:
12266: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12267: fnd_message.set_token('WF_ACT', l_user_activity_name);
12439:
12440: select meaning into l_user_activity_name
12441: from oe_lookups
12442: where lookup_type = DECODE(p_item_type,
12443: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12444: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12445: and lookup_code = p_activity_name;
12446:
12447: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12440: select meaning into l_user_activity_name
12441: from oe_lookups
12442: where lookup_type = DECODE(p_item_type,
12443: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12444: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12445: and lookup_code = p_activity_name;
12446:
12447: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12448: fnd_message.set_token('WF_ACT', l_user_activity_name);
12472:
12473: select meaning into l_user_activity_name
12474: from oe_lookups
12475: where lookup_type = DECODE(p_item_type,
12476: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12477: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12478: and lookup_code = p_activity_name;
12479:
12480: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12473: select meaning into l_user_activity_name
12474: from oe_lookups
12475: where lookup_type = DECODE(p_item_type,
12476: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12477: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12478: and lookup_code = p_activity_name;
12479:
12480: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12481: fnd_message.set_token('WF_ACT', l_user_activity_name);
12650:
12651: select meaning into l_user_activity_name
12652: from oe_lookups
12653: where lookup_type = DECODE(p_item_type,
12654: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12655: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12656: and lookup_code = p_activity_name;
12657:
12658: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12651: select meaning into l_user_activity_name
12652: from oe_lookups
12653: where lookup_type = DECODE(p_item_type,
12654: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12655: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12656: and lookup_code = p_activity_name;
12657:
12658: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12659: fnd_message.set_token('WF_ACT', l_user_activity_name);
12682:
12683: select meaning into l_user_activity_name
12684: from oe_lookups
12685: where lookup_type = DECODE(p_item_type,
12686: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12687: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12688: and lookup_code = p_activity_name;
12689:
12690: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12683: select meaning into l_user_activity_name
12684: from oe_lookups
12685: where lookup_type = DECODE(p_item_type,
12686: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12687: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12688: and lookup_code = p_activity_name;
12689:
12690: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12691: fnd_message.set_token('WF_ACT', l_user_activity_name);
12836:
12837: select meaning into l_user_activity_name
12838: from oe_lookups
12839: where lookup_type = DECODE(p_item_type,
12840: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12841: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12842: and lookup_code = p_activity_name;
12843:
12844: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12837: select meaning into l_user_activity_name
12838: from oe_lookups
12839: where lookup_type = DECODE(p_item_type,
12840: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12841: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12842: and lookup_code = p_activity_name;
12843:
12844: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12845: fnd_message.set_token('WF_ACT', l_user_activity_name);
12870:
12871: select meaning into l_user_activity_name
12872: from oe_lookups
12873: where lookup_type = DECODE(p_item_type,
12874: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12875: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12876: and lookup_code = p_activity_name;
12877:
12878: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12871: select meaning into l_user_activity_name
12872: from oe_lookups
12873: where lookup_type = DECODE(p_item_type,
12874: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12875: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12876: and lookup_code = p_activity_name;
12877:
12878: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12879: fnd_message.set_token('WF_ACT', l_user_activity_name);
13093:
13094: select meaning into l_user_activity_name
13095: from oe_lookups
13096: where lookup_type = DECODE(p_item_type,
13097: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13098: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
13099: and lookup_code = p_activity_name;
13100:
13101: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
13094: select meaning into l_user_activity_name
13095: from oe_lookups
13096: where lookup_type = DECODE(p_item_type,
13097: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13098: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
13099: and lookup_code = p_activity_name;
13100:
13101: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
13102: fnd_message.set_token('WF_ACT', l_user_activity_name);
13123:
13124: select meaning into l_user_activity_name
13125: from oe_lookups
13126: where lookup_type = DECODE(p_item_type,
13127: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13128: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
13129: and lookup_code = p_activity_name;
13130:
13131: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
13124: select meaning into l_user_activity_name
13125: from oe_lookups
13126: where lookup_type = DECODE(p_item_type,
13127: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13128: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
13129: and lookup_code = p_activity_name;
13130:
13131: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
13132: fnd_message.set_token('WF_ACT', l_user_activity_name);
13566:
13567: select meaning into l_user_activity_name
13568: from oe_lookups
13569: where lookup_type = DECODE(p_item_type,
13570: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13571: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
13572: and lookup_code = p_activity_name;
13573:
13574: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
13567: select meaning into l_user_activity_name
13568: from oe_lookups
13569: where lookup_type = DECODE(p_item_type,
13570: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13571: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
13572: and lookup_code = p_activity_name;
13573:
13574: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
13575: fnd_message.set_token('WF_ACT', l_user_activity_name);
13598:
13599: select meaning into l_user_activity_name
13600: from oe_lookups
13601: where lookup_type = DECODE(p_item_type,
13602: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13603: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
13604: and lookup_code = p_activity_name;
13605:
13606: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
13599: select meaning into l_user_activity_name
13600: from oe_lookups
13601: where lookup_type = DECODE(p_item_type,
13602: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13603: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
13604: and lookup_code = p_activity_name;
13605:
13606: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
13607: fnd_message.set_token('WF_ACT', l_user_activity_name);
13778:
13779: select meaning into l_user_activity_name
13780: from oe_lookups
13781: where lookup_type = DECODE(p_item_type,
13782: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13783: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
13784: and lookup_code = p_activity_name;
13785:
13786: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
13779: select meaning into l_user_activity_name
13780: from oe_lookups
13781: where lookup_type = DECODE(p_item_type,
13782: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13783: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
13784: and lookup_code = p_activity_name;
13785:
13786: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
13787: fnd_message.set_token('WF_ACT', l_user_activity_name);
13810:
13811: select meaning into l_user_activity_name
13812: from oe_lookups
13813: where lookup_type = DECODE(p_item_type,
13814: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13815: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
13816: and lookup_code = p_activity_name;
13817:
13818: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
13811: select meaning into l_user_activity_name
13812: from oe_lookups
13813: where lookup_type = DECODE(p_item_type,
13814: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13815: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
13816: and lookup_code = p_activity_name;
13817:
13818: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
13819: fnd_message.set_token('WF_ACT', l_user_activity_name);
13989:
13990: select meaning into l_user_activity_name
13991: from oe_lookups
13992: where lookup_type = DECODE(p_item_type,
13993: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13994: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
13995: and lookup_code = p_activity_name;
13996:
13997: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
13990: select meaning into l_user_activity_name
13991: from oe_lookups
13992: where lookup_type = DECODE(p_item_type,
13993: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13994: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
13995: and lookup_code = p_activity_name;
13996:
13997: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
13998: fnd_message.set_token('WF_ACT', l_user_activity_name);
14021:
14022: select meaning into l_user_activity_name
14023: from oe_lookups
14024: where lookup_type = DECODE(p_item_type,
14025: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
14026: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
14027: and lookup_code = p_activity_name;
14028:
14029: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
14022: select meaning into l_user_activity_name
14023: from oe_lookups
14024: where lookup_type = DECODE(p_item_type,
14025: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
14026: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
14027: and lookup_code = p_activity_name;
14028:
14029: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
14030: fnd_message.set_token('WF_ACT', l_user_activity_name);
14201:
14202: select meaning into l_user_activity_name
14203: from oe_lookups
14204: where lookup_type = DECODE(p_item_type,
14205: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
14206: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
14207: and lookup_code = p_activity_name;
14208:
14209: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
14202: select meaning into l_user_activity_name
14203: from oe_lookups
14204: where lookup_type = DECODE(p_item_type,
14205: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
14206: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
14207: and lookup_code = p_activity_name;
14208:
14209: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
14210: fnd_message.set_token('WF_ACT', l_user_activity_name);
14232:
14233: select meaning into l_user_activity_name
14234: from oe_lookups
14235: where lookup_type = DECODE(p_item_type,
14236: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
14237: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
14238: and lookup_code = p_activity_name;
14239:
14240: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
14233: select meaning into l_user_activity_name
14234: from oe_lookups
14235: where lookup_type = DECODE(p_item_type,
14236: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
14237: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
14238: and lookup_code = p_activity_name;
14239:
14240: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
14241: fnd_message.set_token('WF_ACT', l_user_activity_name);