DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on FND_MESSAGE

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

671:
672: END If;
673:
674: IF l_oe_line_tbl.count = 0 THEN
675: FND_MESSAGE.SET_NAME('ONT','OE_NO_ELIGIBLE_LINES');
676: FND_MESSAGE.SET_TOKEN('ORDER',
677: l_oe_header_rec.Order_Number, FALSE);
678: FND_MSG_PUB.ADD;
679: fnd_msg_pub.count_and_get

Line 676: FND_MESSAGE.SET_TOKEN('ORDER',

672: END If;
673:
674: IF l_oe_line_tbl.count = 0 THEN
675: FND_MESSAGE.SET_NAME('ONT','OE_NO_ELIGIBLE_LINES');
676: FND_MESSAGE.SET_TOKEN('ORDER',
677: l_oe_header_rec.Order_Number, FALSE);
678: FND_MSG_PUB.ADD;
679: fnd_msg_pub.count_and_get
680: ( p_count => x_msg_count

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

740:
741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
742: for counter in REVERSE 1..l_msg_count Loop
743: l_msg := OE_MSG_PUB.Get(counter,FND_API.G_FALSE) ;
744: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
745: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
746: FND_MSG_PUB.ADD;
747: fnd_msg_pub.count_and_get
748: ( p_count => x_msg_count

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

741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
742: for counter in REVERSE 1..l_msg_count Loop
743: l_msg := OE_MSG_PUB.Get(counter,FND_API.G_FALSE) ;
744: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
745: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
746: FND_MSG_PUB.ADD;
747: fnd_msg_pub.count_and_get
748: ( p_count => x_msg_count
749: , p_data => x_msg_data);

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

875:
876: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
877: for counter in REVERSE 1..l_msg_count Loop
878: l_msg := OE_MSG_PUB.Get(counter,FND_API.G_FALSE) ;
879: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
880: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
881: FND_MSG_PUB.ADD;
882: fnd_msg_pub.count_and_get
883: ( p_count => x_msg_count

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

876: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
877: for counter in REVERSE 1..l_msg_count Loop
878: l_msg := OE_MSG_PUB.Get(counter,FND_API.G_FALSE) ;
879: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
880: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
881: FND_MSG_PUB.ADD;
882: fnd_msg_pub.count_and_get
883: ( p_count => x_msg_count
884: , p_data => x_msg_data);

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

913: ,X_MSG_DATA => X_MSG_DATA
914: ,X_RETURN_STATUS => X_RETURN_STATUS);
915: WHEN OTHERS THEN
916: Rollback to Cancel_order_pub;
917: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
918: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
919: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
920: FND_MSG_PUB.ADD;
921: fnd_msg_pub.count_and_get

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

914: ,X_RETURN_STATUS => X_RETURN_STATUS);
915: WHEN OTHERS THEN
916: Rollback to Cancel_order_pub;
917: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
918: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
919: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
920: FND_MSG_PUB.ADD;
921: fnd_msg_pub.count_and_get
922: ( p_count => x_msg_count

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

915: WHEN OTHERS THEN
916: Rollback to Cancel_order_pub;
917: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
918: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
919: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
920: FND_MSG_PUB.ADD;
921: fnd_msg_pub.count_and_get
922: ( p_count => x_msg_count
923: , p_data => x_msg_data);

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

1722: FROM org_organization_Definitions
1723: WHERE organization_id = l_line_tbl(1).source_organization_id;
1724: EXCEPTION
1725: WHEN NO_DATA_FOUND THEN
1726: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1727: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'source_org_operating_unit', FALSE);
1728: FND_MSG_PUB.ADD;
1729: RAISE EXCP_USER_DEFINED;
1730: END;

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

1723: WHERE organization_id = l_line_tbl(1).source_organization_id;
1724: EXCEPTION
1725: WHEN NO_DATA_FOUND THEN
1726: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1727: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'source_org_operating_unit', FALSE);
1728: FND_MSG_PUB.ADD;
1729: RAISE EXCP_USER_DEFINED;
1730: END;
1731:

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

1878: l_oe_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1879:
1880: ELSIF (l_header_rec.operation = G_OPR_UPDATE) THEN
1881: IF (l_header_rec.order_header_id is null) THEN
1882: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1883: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_header_rec.order_header_id', FALSE);
1884:
1885: FND_MSG_PUB.ADD;
1886: RAISE EXCP_USER_DEFINED;

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

1879:
1880: ELSIF (l_header_rec.operation = G_OPR_UPDATE) THEN
1881: IF (l_header_rec.order_header_id is null) THEN
1882: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1883: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_header_rec.order_header_id', FALSE);
1884:
1885: FND_MSG_PUB.ADD;
1886: RAISE EXCP_USER_DEFINED;
1887: END IF;

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

1942: OPEN item_desc_cur(l_line_tbl(i).inventory_item_id, l_line_tbl(i).source_organization_id);
1943: FETCH item_desc_cur INTO l_line_tbl(i).item_description;
1944: IF item_Desc_cur%NOTFOUND THEN
1945: CLOSE item_desc_cur;
1946: FND_MESSAGE.SET_NAME ('ONT', 'OE_INVALID_ITEM_WHSE');
1947: FND_MSG_PUB.ADD;
1948: RAISE FND_API.G_EXC_ERROR;
1949: END IF;
1950: CLOSE item_desc_cur;

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

2361:
2362: ELSIF (l_header_rec.operation = CSP_PARTS_ORDER.G_OPR_UPDATE) THEN
2363: IF (p_process_Type = 'REQUISITION') THEN
2364: IF (l_line_Tbl(I).requisition_line_id IS NULL) THEN
2365: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
2366: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requisition_line_id', FALSE);
2367: FND_MSG_PUB.ADD;
2368: RAISE EXCP_USER_DEFINED;
2369: END IF;

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

2362: ELSIF (l_header_rec.operation = CSP_PARTS_ORDER.G_OPR_UPDATE) THEN
2363: IF (p_process_Type = 'REQUISITION') THEN
2364: IF (l_line_Tbl(I).requisition_line_id IS NULL) THEN
2365: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
2366: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requisition_line_id', FALSE);
2367: FND_MSG_PUB.ADD;
2368: RAISE EXCP_USER_DEFINED;
2369: END IF;
2370:

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

2400: END IF;
2401:
2402: ELSIF (p_process_type in ('ORDER', 'BOTH')) THEN
2403: IF (l_line_tbl(i).order_line_id IS NULL) THEN
2404: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
2405: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.order_line_id', FALSE);
2406:
2407: FND_MSG_PUB.ADD;
2408: RAISE EXCP_USER_DEFINED;

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

2401:
2402: ELSIF (p_process_type in ('ORDER', 'BOTH')) THEN
2403: IF (l_line_tbl(i).order_line_id IS NULL) THEN
2404: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
2405: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.order_line_id', FALSE);
2406:
2407: FND_MSG_PUB.ADD;
2408: RAISE EXCP_USER_DEFINED;
2409: END IF;

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

2580: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);
2581: mo_global.set_org_context(l_source_operating_unit,null,'CSF');
2582: /* fnd_profile.get('ORG_ID',new_org_id); --Operating Unit for the new context.
2583: IF l_source_operating_unit <> new_org_id THEN
2584: FND_MESSAGE.Set_Name('CS','CS_CHG_NEW_CONTEXT_OU_NOT_MATCH'); --to be seeded.
2585: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
2586: FND_MSG_PUB.Add;
2587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2588: END IF;

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

2581: mo_global.set_org_context(l_source_operating_unit,null,'CSF');
2582: /* fnd_profile.get('ORG_ID',new_org_id); --Operating Unit for the new context.
2583: IF l_source_operating_unit <> new_org_id THEN
2584: FND_MESSAGE.Set_Name('CS','CS_CHG_NEW_CONTEXT_OU_NOT_MATCH'); --to be seeded.
2585: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
2586: FND_MSG_PUB.Add;
2587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2588: END IF;
2589: */

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

2691:
2692: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2693: for counter in REVERSE 1..l_msg_count Loop
2694: l_msg := OE_MSG_PUB.Get(counter,FND_API.G_FALSE) ;
2695: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2696: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2697: FND_MSG_PUB.ADD;
2698: fnd_msg_pub.count_and_get
2699: ( p_count => x_msg_count

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

2692: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2693: for counter in REVERSE 1..l_msg_count Loop
2694: l_msg := OE_MSG_PUB.Get(counter,FND_API.G_FALSE) ;
2695: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');
2696: FND_MESSAGE.SET_TOKEN('OM_MSG', l_msg, FALSE);
2697: FND_MSG_PUB.ADD;
2698: fnd_msg_pub.count_and_get
2699: ( p_count => x_msg_count
2700: , p_data => x_msg_data);

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

2807: raise;
2808:
2809: WHEN OTHERS THEN
2810: Rollback to process_order_pub;
2811: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2812: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2813: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2814: FND_MSG_PUB.ADD;
2815: fnd_msg_pub.count_and_get

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

2808:
2809: WHEN OTHERS THEN
2810: Rollback to process_order_pub;
2811: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2812: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2813: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2814: FND_MSG_PUB.ADD;
2815: fnd_msg_pub.count_and_get
2816: ( p_count => x_msg_count

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

2809: WHEN OTHERS THEN
2810: Rollback to process_order_pub;
2811: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2812: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2813: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2814: FND_MSG_PUB.ADD;
2815: fnd_msg_pub.count_and_get
2816: ( p_count => x_msg_count
2817: , p_data => x_msg_data);

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

3167: raise;
3168:
3169: WHEN OTHERS THEN
3170: Rollback to process_order_pub;
3171: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3172: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
3173: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
3174: FND_MSG_PUB.ADD;
3175: fnd_msg_pub.count_and_get

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

3168:
3169: WHEN OTHERS THEN
3170: Rollback to process_order_pub;
3171: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3172: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
3173: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
3174: FND_MSG_PUB.ADD;
3175: fnd_msg_pub.count_and_get
3176: ( p_count => x_msg_count

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

3169: WHEN OTHERS THEN
3170: Rollback to process_order_pub;
3171: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3172: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
3173: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
3174: FND_MSG_PUB.ADD;
3175: fnd_msg_pub.count_and_get
3176: ( p_count => x_msg_count
3177: , p_data => x_msg_data);