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.CSP_PARTS_ORDER dependencies on FND_MSG_PUB

Line 735: FND_MSG_PUB.ADD;

731: IF l_oe_line_tbl.count = 0 THEN
732: FND_MESSAGE.SET_NAME('ONT','OE_NO_ELIGIBLE_LINES');
733: FND_MESSAGE.SET_TOKEN('ORDER',
734: l_oe_header_rec.Order_Number, FALSE);
735: FND_MSG_PUB.ADD;
736: fnd_msg_pub.count_and_get
737: ( p_count => x_msg_count
738: , p_data => x_msg_data);
739:

Line 736: fnd_msg_pub.count_and_get

732: FND_MESSAGE.SET_NAME('ONT','OE_NO_ELIGIBLE_LINES');
733: FND_MESSAGE.SET_TOKEN('ORDER',
734: l_oe_header_rec.Order_Number, FALSE);
735: FND_MSG_PUB.ADD;
736: fnd_msg_pub.count_and_get
737: ( p_count => x_msg_count
738: , p_data => x_msg_data);
739:
740: x_return_status := FND_API.G_RET_STS_ERROR;

Line 825: FND_MSG_PUB.ADD;

821: for counter in REVERSE 1..l_msg_count Loop
822: l_msg := OE_MSG_PUB.Get(counter,FND_API.G_FALSE) ;
823: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
824: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
825: FND_MSG_PUB.ADD;
826: fnd_msg_pub.count_and_get
827: ( p_count => x_msg_count
828: , p_data => x_msg_data);
829: End loop;

Line 826: fnd_msg_pub.count_and_get

822: l_msg := OE_MSG_PUB.Get(counter,FND_API.G_FALSE) ;
823: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
824: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
825: FND_MSG_PUB.ADD;
826: fnd_msg_pub.count_and_get
827: ( p_count => x_msg_count
828: , p_data => x_msg_data);
829: End loop;
830: RAISE FND_API.G_EXC_ERROR;

Line 984: FND_MSG_PUB.ADD;

980: for counter in REVERSE 1..l_msg_count Loop
981: l_msg := OE_MSG_PUB.Get(counter,FND_API.G_FALSE) ;
982: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
983: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
984: FND_MSG_PUB.ADD;
985: fnd_msg_pub.count_and_get
986: ( p_count => x_msg_count
987: , p_data => x_msg_data);
988: End loop;

Line 985: fnd_msg_pub.count_and_get

981: l_msg := OE_MSG_PUB.Get(counter,FND_API.G_FALSE) ;
982: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
983: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
984: FND_MSG_PUB.ADD;
985: fnd_msg_pub.count_and_get
986: ( p_count => x_msg_count
987: , p_data => x_msg_data);
988: End loop;
989: RAISE FND_API.G_EXC_ERROR;

Line 1008: fnd_msg_pub.count_and_get

1004: null;
1005: END;
1006: END LOOP;
1007:
1008: fnd_msg_pub.count_and_get
1009: ( p_count => x_msg_count
1010: , p_data => x_msg_data);
1011:
1012: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1022: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1018: WHEN FND_API.G_EXC_ERROR THEN
1019: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1020: P_API_NAME => L_API_NAME
1021: ,P_PKG_NAME => G_PKG_NAME
1022: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1023: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1024: ,X_MSG_COUNT => X_MSG_COUNT
1025: ,X_MSG_DATA => X_MSG_DATA
1026: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1031: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1028: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1029: P_API_NAME => L_API_NAME
1030: ,P_PKG_NAME => G_PKG_NAME
1031: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1032: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1033: ,X_MSG_COUNT => X_MSG_COUNT
1034: ,X_MSG_DATA => X_MSG_DATA
1035: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1041: FND_MSG_PUB.ADD;

1037: Rollback to Cancel_order_pub;
1038: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1039: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1040: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1041: FND_MSG_PUB.ADD;
1042: fnd_msg_pub.count_and_get
1043: ( p_count => x_msg_count
1044: , p_data => x_msg_data);
1045: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1042: fnd_msg_pub.count_and_get

1038: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1039: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1040: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1041: FND_MSG_PUB.ADD;
1042: fnd_msg_pub.count_and_get
1043: ( p_count => x_msg_count
1044: , p_data => x_msg_data);
1045: x_return_status := FND_API.G_RET_STS_ERROR;
1046:

Line 1605: FND_MSG_PUB.initialize;

1601: SAVEPOINT Process_Order_PUB;
1602:
1603: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1604: -- initialize message list
1605: FND_MSG_PUB.initialize;
1606: END IF;
1607:
1608: -- Standard call to check for call compatibility.
1609: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1680: FND_MSG_PUB.ADD;

1676: EXCEPTION
1677: WHEN NO_DATA_FOUND THEN
1678: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1679: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_dest_operating_unit', FALSE);
1680: FND_MSG_PUB.ADD;
1681: RAISE EXCP_USER_DEFINED;
1682: END;
1683:
1684: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2207: FND_MSG_PUB.ADD;

2203: EXCEPTION
2204: WHEN NO_DATA_FOUND THEN
2205: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
2206: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'source_org_operating_unit', FALSE);
2207: FND_MSG_PUB.ADD;
2208: RAISE EXCP_USER_DEFINED;
2209: END;
2210:
2211: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2398: FND_MSG_PUB.ADD;

2394: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2395: l_msg := x_msg_data;
2396: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2397: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2398: FND_MSG_PUB.ADD;
2399: fnd_msg_pub.count_and_get
2400: ( p_count => x_msg_count
2401: , p_data => x_msg_data);
2402: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2399: fnd_msg_pub.count_and_get

2395: l_msg := x_msg_data;
2396: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2397: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2398: FND_MSG_PUB.ADD;
2399: fnd_msg_pub.count_and_get
2400: ( p_count => x_msg_count
2401: , p_data => x_msg_data);
2402: x_return_status := FND_API.G_RET_STS_ERROR;
2403: --dbms_application_info.set_client_info(l_org_id);

Line 2436: FND_MSG_PUB.ADD;

2432: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2433: l_msg := x_msg_data;
2434: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2435: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2436: FND_MSG_PUB.ADD;
2437: fnd_msg_pub.count_and_get
2438: ( p_count => x_msg_count
2439: , p_data => x_msg_data);
2440: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2437: fnd_msg_pub.count_and_get

2433: l_msg := x_msg_data;
2434: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2435: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2436: FND_MSG_PUB.ADD;
2437: fnd_msg_pub.count_and_get
2438: ( p_count => x_msg_count
2439: , p_data => x_msg_data);
2440: x_return_status := FND_API.G_RET_STS_ERROR;
2441: RAISE FND_API.G_EXC_ERROR;

Line 2475: FND_MSG_PUB.ADD;

2471: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2472: l_msg := x_msg_data;
2473: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2474: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2475: FND_MSG_PUB.ADD;
2476: fnd_msg_pub.count_and_get
2477: ( p_count => x_msg_count
2478: , p_data => x_msg_data);
2479: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2476: fnd_msg_pub.count_and_get

2472: l_msg := x_msg_data;
2473: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2474: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2475: FND_MSG_PUB.ADD;
2476: fnd_msg_pub.count_and_get
2477: ( p_count => x_msg_count
2478: , p_data => x_msg_data);
2479: x_return_status := FND_API.G_RET_STS_ERROR;
2480: --dbms_application_info.set_client_info(l_org_id);

Line 2534: FND_MSG_PUB.ADD;

2530: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2531: l_msg := x_msg_data;
2532: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2533: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2534: FND_MSG_PUB.ADD;
2535: fnd_msg_pub.count_and_get
2536: ( p_count => x_msg_count
2537: , p_data => x_msg_data);
2538: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2535: fnd_msg_pub.count_and_get

2531: l_msg := x_msg_data;
2532: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2533: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2534: FND_MSG_PUB.ADD;
2535: fnd_msg_pub.count_and_get
2536: ( p_count => x_msg_count
2537: , p_data => x_msg_data);
2538: x_return_status := FND_API.G_RET_STS_ERROR;
2539: RAISE FND_API.G_EXC_ERROR;

Line 2569: FND_MSG_PUB.ADD;

2565: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2566: l_msg := x_msg_data;
2567: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2568: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2569: FND_MSG_PUB.ADD;
2570: fnd_msg_pub.count_and_get
2571: ( p_count => x_msg_count
2572: , p_data => x_msg_data);
2573: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2570: fnd_msg_pub.count_and_get

2566: l_msg := x_msg_data;
2567: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2568: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2569: FND_MSG_PUB.ADD;
2570: fnd_msg_pub.count_and_get
2571: ( p_count => x_msg_count
2572: , p_data => x_msg_data);
2573: x_return_status := FND_API.G_RET_STS_ERROR;
2574: RAISE FND_API.G_EXC_ERROR;

Line 2605: FND_MSG_PUB.ADD;

2601: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2602: l_msg := x_msg_data;
2603: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2604: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2605: FND_MSG_PUB.ADD;
2606: fnd_msg_pub.count_and_get
2607: ( p_count => x_msg_count
2608: , p_data => x_msg_data);
2609: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2606: fnd_msg_pub.count_and_get

2602: l_msg := x_msg_data;
2603: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2604: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2605: FND_MSG_PUB.ADD;
2606: fnd_msg_pub.count_and_get
2607: ( p_count => x_msg_count
2608: , p_data => x_msg_data);
2609: x_return_status := FND_API.G_RET_STS_ERROR;
2610: RAISE FND_API.G_EXC_ERROR;

Line 2643: FND_MSG_PUB.ADD;

2639: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2640: l_msg := x_msg_data;
2641: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2642: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2643: FND_MSG_PUB.ADD;
2644: fnd_msg_pub.count_and_get
2645: ( p_count => x_msg_count
2646: , p_data => x_msg_data);
2647: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2644: fnd_msg_pub.count_and_get

2640: l_msg := x_msg_data;
2641: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2642: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2643: FND_MSG_PUB.ADD;
2644: fnd_msg_pub.count_and_get
2645: ( p_count => x_msg_count
2646: , p_data => x_msg_data);
2647: x_return_status := FND_API.G_RET_STS_ERROR;
2648: po_moac_utils_pvt.set_org_context(l_org_id);

Line 2696: FND_MSG_PUB.ADD;

2692: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2693: l_msg := x_msg_data;
2694: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2695: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2696: FND_MSG_PUB.ADD;
2697: fnd_msg_pub.count_and_get
2698: ( p_count => x_msg_count
2699: , p_data => x_msg_data);
2700: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2697: fnd_msg_pub.count_and_get

2693: l_msg := x_msg_data;
2694: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2695: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2696: FND_MSG_PUB.ADD;
2697: fnd_msg_pub.count_and_get
2698: ( p_count => x_msg_count
2699: , p_data => x_msg_data);
2700: x_return_status := FND_API.G_RET_STS_ERROR;
2701: --dbms_application_info.set_client_info(l_org_id);

Line 2815: FND_MSG_PUB.ADD;

2811: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2812: l_msg := x_msg_data;
2813: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2814: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2815: FND_MSG_PUB.ADD;
2816: fnd_msg_pub.count_and_get
2817: ( p_count => x_msg_count
2818: , p_data => x_msg_data);
2819: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2816: fnd_msg_pub.count_and_get

2812: l_msg := x_msg_data;
2813: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2814: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2815: FND_MSG_PUB.ADD;
2816: fnd_msg_pub.count_and_get
2817: ( p_count => x_msg_count
2818: , p_data => x_msg_data);
2819: x_return_status := FND_API.G_RET_STS_ERROR;
2820: RAISE FND_API.G_EXC_ERROR;

Line 2850: FND_MSG_PUB.ADD;

2846: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2847: l_msg := x_msg_data;
2848: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2849: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2850: FND_MSG_PUB.ADD;
2851: fnd_msg_pub.count_and_get
2852: ( p_count => x_msg_count
2853: , p_data => x_msg_data);
2854: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2851: fnd_msg_pub.count_and_get

2847: l_msg := x_msg_data;
2848: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2849: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2850: FND_MSG_PUB.ADD;
2851: fnd_msg_pub.count_and_get
2852: ( p_count => x_msg_count
2853: , p_data => x_msg_data);
2854: x_return_status := FND_API.G_RET_STS_ERROR;
2855: RAISE FND_API.G_EXC_ERROR;

Line 2880: FND_MSG_PUB.ADD;

2876: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2877: l_msg := x_msg_data;
2878: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2879: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2880: FND_MSG_PUB.ADD;
2881: fnd_msg_pub.count_and_get
2882: ( p_count => x_msg_count
2883: , p_data => x_msg_data);
2884: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2881: fnd_msg_pub.count_and_get

2877: l_msg := x_msg_data;
2878: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2879: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2880: FND_MSG_PUB.ADD;
2881: fnd_msg_pub.count_and_get
2882: ( p_count => x_msg_count
2883: , p_data => x_msg_data);
2884: x_return_status := FND_API.G_RET_STS_ERROR;
2885: RAISE FND_API.G_EXC_ERROR;

Line 2918: FND_MSG_PUB.ADD;

2914: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2915: l_msg := x_msg_data;
2916: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2917: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2918: FND_MSG_PUB.ADD;
2919: fnd_msg_pub.count_and_get
2920: ( p_count => x_msg_count
2921: , p_data => x_msg_data);
2922: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2919: fnd_msg_pub.count_and_get

2915: l_msg := x_msg_data;
2916: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2917: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2918: FND_MSG_PUB.ADD;
2919: fnd_msg_pub.count_and_get
2920: ( p_count => x_msg_count
2921: , p_data => x_msg_data);
2922: x_return_status := FND_API.G_RET_STS_ERROR;
2923: po_moac_utils_pvt.set_org_context(l_org_id);

Line 3040: FND_MSG_PUB.ADD;

3036: IF (l_header_rec.order_header_id is null) THEN
3037: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
3038: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_header_rec.order_header_id', FALSE);
3039:
3040: FND_MSG_PUB.ADD;
3041: RAISE EXCP_USER_DEFINED;
3042: END IF;
3043:
3044: oe_header_util.Query_Row(

Line 3119: FND_MSG_PUB.ADD;

3115: FND_MESSAGE.SET_TOKEN ('ITM', l_line_tbl(i).item_description, FALSE);
3116: FND_MESSAGE.SET_TOKEN ('ORG', l_line_tbl(i).ATTRIBUTE1, FALSE);
3117: end if;
3118:
3119: FND_MSG_PUB.ADD;
3120: RAISE FND_API.G_EXC_ERROR;
3121: END IF;
3122: CLOSE item_desc_cur;
3123:

Line 3131: FND_MSG_PUB.ADD;

3127: FETCH item_desc_cur INTO l_line_tbl(i).item_description;
3128: IF item_Desc_cur%NOTFOUND THEN
3129: CLOSE item_desc_cur;
3130: FND_MESSAGE.SET_NAME ('ONT', 'OE_INVALID_ITEM_WHSE');
3131: FND_MSG_PUB.ADD;
3132: RAISE FND_API.G_EXC_ERROR;
3133: END IF;
3134: CLOSE item_desc_cur;
3135: --END IF;

Line 3632: FND_MSG_PUB.ADD;

3628: IF (p_process_Type = 'REQUISITION') THEN
3629: IF (l_line_Tbl(I).requisition_line_id IS NULL) THEN
3630: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
3631: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requisition_line_id', FALSE);
3632: FND_MSG_PUB.ADD;
3633: RAISE EXCP_USER_DEFINED;
3634: END IF;
3635:
3636: -- update requisition line table with new quantity

Line 3672: FND_MSG_PUB.ADD;

3668: IF (l_line_tbl(i).order_line_id IS NULL) THEN
3669: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
3670: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.order_line_id', FALSE);
3671:
3672: FND_MSG_PUB.ADD;
3673: RAISE EXCP_USER_DEFINED;
3674: END IF;
3675:
3676: -- l_oe_line_Rec := oe_line_util.Query_Row(l_line_tbl(i).order_line_id);

Line 3860: FND_MSG_PUB.Add;

3856: /* fnd_profile.get('ORG_ID',new_org_id); --Operating Unit for the new context.
3857: IF l_source_operating_unit <> new_org_id THEN
3858: FND_MESSAGE.Set_Name('CS','CS_CHG_NEW_CONTEXT_OU_NOT_MATCH'); --to be seeded.
3859: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
3860: FND_MSG_PUB.Add;
3861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3862: END IF;
3863: */
3864: ELSE

Line 4161: FND_MSG_PUB.ADD;

4157: for counter in REVERSE 1..l_msg_count Loop
4158: l_msg := OE_MSG_PUB.Get(counter,FND_API.G_FALSE) ;
4159: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
4160: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
4161: FND_MSG_PUB.ADD;
4162: fnd_msg_pub.count_and_get
4163: ( p_count => x_msg_count
4164: , p_data => x_msg_data);
4165: End loop;

Line 4162: fnd_msg_pub.count_and_get

4158: l_msg := OE_MSG_PUB.Get(counter,FND_API.G_FALSE) ;
4159: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
4160: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
4161: FND_MSG_PUB.ADD;
4162: fnd_msg_pub.count_and_get
4163: ( p_count => x_msg_count
4164: , p_data => x_msg_data);
4165: End loop;
4166: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4232: fnd_msg_pub.count_and_get

4228:
4229: px_header_rec := l_header_rec;
4230: px_line_table := l_line_tbl;
4231:
4232: fnd_msg_pub.count_and_get
4233: ( p_count => x_msg_count
4234: , p_data => x_msg_data);
4235:
4236: END If;

Line 4264: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4260: WHEN FND_API.G_EXC_ERROR THEN
4261: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4262: P_API_NAME => L_API_NAME
4263: ,P_PKG_NAME => G_PKG_NAME
4264: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4265: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4266: ,X_MSG_COUNT => X_MSG_COUNT
4267: ,X_MSG_DATA => X_MSG_DATA
4268: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4273: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4270: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4271: P_API_NAME => L_API_NAME
4272: ,P_PKG_NAME => G_PKG_NAME
4273: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4274: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4275: ,X_MSG_COUNT => X_MSG_COUNT
4276: ,X_MSG_DATA => X_MSG_DATA
4277: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4300: FND_MSG_PUB.ADD;

4296: Rollback to process_order_pub;
4297: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4298: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
4299: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
4300: FND_MSG_PUB.ADD;
4301: fnd_msg_pub.count_and_get
4302: ( p_count => x_msg_count
4303: , p_data => x_msg_data);
4304: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4301: fnd_msg_pub.count_and_get

4297: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4298: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
4299: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
4300: FND_MSG_PUB.ADD;
4301: fnd_msg_pub.count_and_get
4302: ( p_count => x_msg_count
4303: , p_data => x_msg_data);
4304: x_return_status := FND_API.G_RET_STS_ERROR;
4305: END;

Line 4401: FND_MSG_PUB.initialize;

4397: SAVEPOINT Process_Order_PUB;
4398:
4399: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
4400: -- initialize message list
4401: FND_MSG_PUB.initialize;
4402: END IF;
4403:
4404: -- Standard call to check for call compatibility.
4405: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 4443: FND_MSG_PUB.ADD;

4439: EXCEPTION
4440: WHEN NO_DATA_FOUND THEN
4441: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
4442: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_dest_operating_unit', FALSE);
4443: FND_MSG_PUB.ADD;
4444: RAISE EXCP_USER_DEFINED;
4445: END;
4446:
4447: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 4698: fnd_msg_pub.count_and_get( p_count => x_msg_count

4694: IF (p_commit = FND_API.G_TRUE) THEN
4695: commit;
4696: END IF;
4697:
4698: fnd_msg_pub.count_and_get( p_count => x_msg_count
4699: , p_data => x_msg_data);
4700:
4701: EXCEPTION
4702: WHEN FND_API.G_EXC_ERROR THEN

Line 4706: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4702: WHEN FND_API.G_EXC_ERROR THEN
4703: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4704: P_API_NAME => L_API_NAME
4705: ,P_PKG_NAME => G_PKG_NAME
4706: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4707: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4708: ,X_MSG_COUNT => X_MSG_COUNT
4709: ,X_MSG_DATA => X_MSG_DATA
4710: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4715: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4712: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4713: P_API_NAME => L_API_NAME
4714: ,P_PKG_NAME => G_PKG_NAME
4715: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4716: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4717: ,X_MSG_COUNT => X_MSG_COUNT
4718: ,X_MSG_DATA => X_MSG_DATA
4719: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4730: FND_MSG_PUB.ADD;

4726: Rollback to process_order_pub;
4727: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4728: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
4729: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
4730: FND_MSG_PUB.ADD;
4731: fnd_msg_pub.count_and_get
4732: ( p_count => x_msg_count
4733: , p_data => x_msg_data);
4734: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4731: fnd_msg_pub.count_and_get

4727: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4728: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
4729: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
4730: FND_MSG_PUB.ADD;
4731: fnd_msg_pub.count_and_get
4732: ( p_count => x_msg_count
4733: , p_data => x_msg_data);
4734: x_return_status := FND_API.G_RET_STS_ERROR;
4735: END;

Line 5187: FND_MSG_PUB.ADD;

5183: end if;
5184:
5185: FND_MESSAGE.SET_NAME('CSP', 'CSP_NO-SHIP_CNG_BOOK_IO');
5186: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_booked_orders, FALSE);
5187: FND_MSG_PUB.ADD;
5188: fnd_msg_pub.count_and_get
5189: ( p_count => x_msg_count
5190: , p_data => x_msg_data);
5191: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5188: fnd_msg_pub.count_and_get

5184:
5185: FND_MESSAGE.SET_NAME('CSP', 'CSP_NO-SHIP_CNG_BOOK_IO');
5186: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_booked_orders, FALSE);
5187: FND_MSG_PUB.ADD;
5188: fnd_msg_pub.count_and_get
5189: ( p_count => x_msg_count
5190: , p_data => x_msg_data);
5191: x_return_status := FND_API.G_RET_STS_ERROR;
5192: