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_MESSAGE

Line 732: FND_MESSAGE.SET_NAME('ONT','OE_NO_ELIGIBLE_LINES');

728:
729: END If;
730:
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

Line 733: FND_MESSAGE.SET_TOKEN('ORDER',

729: END If;
730:
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

Line 823: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

819: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
820: x_return_status := l_return_status;
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

Line 824: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);

820: x_return_status := l_return_status;
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);

Line 982: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

978: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
979: x_return_status := l_return_status;
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

Line 983: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);

979: x_return_status := l_return_status;
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);

Line 1038: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

1034: ,X_MSG_DATA => X_MSG_DATA
1035: ,X_RETURN_STATUS => X_RETURN_STATUS);
1036: WHEN OTHERS THEN
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

Line 1039: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

1035: ,X_RETURN_STATUS => X_RETURN_STATUS);
1036: WHEN OTHERS THEN
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

Line 1040: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

1036: WHEN OTHERS THEN
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);

Line 1678: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

1674: FROM org_organization_Definitions
1675: WHERE organization_id = l_header_rec.dest_organization_id;
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;

Line 1679: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_dest_operating_unit', FALSE);

1675: WHERE organization_id = l_header_rec.dest_organization_id;
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:

Line 2205: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

2201: FROM org_organization_Definitions
2202: WHERE organization_id = l_line_tbl(1).source_organization_id;
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;

Line 2206: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'source_org_operating_unit', FALSE);

2202: WHERE organization_id = l_line_tbl(1).source_organization_id;
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:

Line 2396: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

2392: po_moac_utils_pvt.set_org_context(l_tmp_org_id);
2393:
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

Line 2397: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);

2393:
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);

Line 2434: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

2430: po_moac_utils_pvt.set_org_context(l_org_id);
2431:
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

Line 2435: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);

2431:
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);

Line 2473: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

2469: po_moac_utils_pvt.set_org_context(l_org_id);
2470:
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

Line 2474: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);

2470:
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);

Line 2532: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

2528: po_moac_utils_pvt.set_org_context(l_tmp_org_id);
2529:
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

Line 2533: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);

2529:
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);

Line 2567: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

2563: po_moac_utils_pvt.set_org_context(l_org_id);
2564:
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

Line 2568: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);

2564:
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);

Line 2603: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

2599: po_moac_utils_pvt.set_org_context(l_org_id);
2600:
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

Line 2604: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);

2600:
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);

Line 2641: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

2637: po_moac_utils_pvt.set_org_context(l_org_id);
2638:
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

Line 2642: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);

2638:
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);

Line 2694: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

2690: po_moac_utils_pvt.set_org_context(l_org_id);
2691:
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

Line 2695: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);

2691:
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);

Line 2813: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

2809: po_moac_utils_pvt.set_org_context(l_org_id);
2810:
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

Line 2814: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);

2810:
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);

Line 2848: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

2844: po_moac_utils_pvt.set_org_context(l_org_id);
2845:
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

Line 2849: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);

2845:
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);

Line 2878: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

2874: po_moac_utils_pvt.set_org_context(l_org_id);
2875:
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

Line 2879: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);

2875:
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);

Line 2916: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

2912: po_moac_utils_pvt.set_org_context(l_org_id);
2913:
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

Line 2917: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);

2913:
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);

Line 3037: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

3033: l_oe_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;
3034:
3035: ELSIF (l_header_rec.operation = G_OPR_UPDATE) THEN
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;

Line 3038: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_header_rec.order_header_id', FALSE);

3034:
3035: ELSIF (l_header_rec.operation = G_OPR_UPDATE) THEN
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;

Line 3100: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_ITEM_ORGN');

3096: OPEN item_desc_cur(l_line_tbl(i).inventory_item_id, l_header_rec.dest_organization_id);
3097: FETCH item_desc_cur INTO l_line_tbl(i).item_description;
3098: IF item_Desc_cur%NOTFOUND THEN
3099: CLOSE item_desc_cur;
3100: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_ITEM_ORGN');
3101: FND_PROFILE.GET('CS_INV_VALIDATION_ORG', l_line_tbl(i).source_organization_id); -- taking dummy variable as we are going to throw an error only
3102:
3103: if l_line_tbl(i).source_organization_id is not null then
3104: SELECT concatenated_segments

Line 3115: FND_MESSAGE.SET_TOKEN ('ITM', l_line_tbl(i).item_description, FALSE);

3111: into l_line_tbl(i).ATTRIBUTE1 -- taking dummy variable as we are going to throw an error only
3112: from mtl_parameters
3113: where organization_id = l_header_rec.dest_organization_id;
3114:
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;

Line 3116: FND_MESSAGE.SET_TOKEN ('ORG', l_line_tbl(i).ATTRIBUTE1, FALSE);

3112: from mtl_parameters
3113: where organization_id = l_header_rec.dest_organization_id;
3114:
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;

Line 3130: FND_MESSAGE.SET_NAME ('ONT', 'OE_INVALID_ITEM_WHSE');

3126: OPEN item_desc_cur(l_line_tbl(i).inventory_item_id, l_line_tbl(i).source_organization_id);
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;

Line 3630: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

3626:
3627: ELSIF (l_header_rec.operation = CSP_PARTS_ORDER.G_OPR_UPDATE) THEN
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;

Line 3631: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requisition_line_id', FALSE);

3627: ELSIF (l_header_rec.operation = CSP_PARTS_ORDER.G_OPR_UPDATE) THEN
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:

Line 3669: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

3665: END IF;
3666:
3667: ELSIF (p_process_type in ('ORDER', 'BOTH')) THEN
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;

Line 3670: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.order_line_id', FALSE);

3666:
3667: ELSIF (p_process_type in ('ORDER', 'BOTH')) THEN
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;

Line 3858: FND_MESSAGE.Set_Name('CS','CS_CHG_NEW_CONTEXT_OU_NOT_MATCH'); --to be seeded.

3854: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);
3855: mo_global.set_policy_context('S', l_source_operating_unit);
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;

Line 3859: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);

3855: mo_global.set_policy_context('S', l_source_operating_unit);
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: */

Line 4159: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

4155:
4156: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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

Line 4160: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);

4156: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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);

Line 4297: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

4293: raise;
4294:
4295: WHEN OTHERS THEN
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

Line 4298: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

4294:
4295: WHEN OTHERS THEN
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

Line 4299: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

4295: WHEN OTHERS THEN
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);

Line 4441: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

4437: FROM org_organization_Definitions
4438: WHERE organization_id = l_header_rec.dest_organization_id;
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;

Line 4442: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_dest_operating_unit', FALSE);

4438: WHERE organization_id = l_header_rec.dest_organization_id;
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:

Line 4727: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

4723: raise;
4724:
4725: WHEN OTHERS THEN
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

Line 4728: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

4724:
4725: WHEN OTHERS THEN
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

Line 4729: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

4725: WHEN OTHERS THEN
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);

Line 5185: FND_MESSAGE.SET_NAME('CSP', 'CSP_NO-SHIP_CNG_BOOK_IO');

5181: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5182: 'Raising error as l_booked_orders > 0 ');
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

Line 5186: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_booked_orders, FALSE);

5182: 'Raising error as l_booked_orders > 0 ');
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);