DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on FND_MSG_PUB

Line 678: FND_MSG_PUB.ADD;

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
681: , p_data => x_msg_data);
682:

Line 679: fnd_msg_pub.count_and_get

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
681: , p_data => x_msg_data);
682:
683: x_return_status := FND_API.G_RET_STS_ERROR;

Line 746: FND_MSG_PUB.ADD;

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);
750: End loop;

Line 747: fnd_msg_pub.count_and_get

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);
750: End loop;
751: RAISE FND_API.G_EXC_ERROR;

Line 881: FND_MSG_PUB.ADD;

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);
885: End loop;

Line 882: fnd_msg_pub.count_and_get

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);
885: End loop;
886: RAISE FND_API.G_EXC_ERROR;

Line 892: fnd_msg_pub.count_and_get

888: END IF;
889: END IF;
890: END If;
891:
892: fnd_msg_pub.count_and_get
893: ( p_count => x_msg_count
894: , p_data => x_msg_data);
895:
896: EXCEPTION

Line 901: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

897: WHEN FND_API.G_EXC_ERROR THEN
898: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
899: P_API_NAME => L_API_NAME
900: ,P_PKG_NAME => G_PKG_NAME
901: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
902: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
903: ,X_MSG_COUNT => X_MSG_COUNT
904: ,X_MSG_DATA => X_MSG_DATA
905: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 910: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
907: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
908: P_API_NAME => L_API_NAME
909: ,P_PKG_NAME => G_PKG_NAME
910: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
911: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
912: ,X_MSG_COUNT => X_MSG_COUNT
913: ,X_MSG_DATA => X_MSG_DATA
914: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 920: FND_MSG_PUB.ADD;

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);
924: x_return_status := FND_API.G_RET_STS_ERROR;

Line 921: fnd_msg_pub.count_and_get

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);
924: x_return_status := FND_API.G_RET_STS_ERROR;
925:

Line 1263: FND_MSG_PUB.initialize;

1259: SAVEPOINT Process_Order_PUB;
1260:
1261: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1262: -- initialize message list
1263: FND_MSG_PUB.initialize;
1264: END IF;
1265:
1266: -- Standard call to check for call compatibility.
1267: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1728: FND_MSG_PUB.ADD;

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:
1732: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1885: FND_MSG_PUB.ADD;

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;
1888:
1889: oe_header_util.Query_Row(

Line 1947: FND_MSG_PUB.ADD;

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;
1951: END IF;

Line 2367: FND_MSG_PUB.ADD;

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:
2371: -- update requisition line table with new quantity

Line 2407: FND_MSG_PUB.ADD;

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;
2410:
2411: -- l_oe_line_Rec := oe_line_util.Query_Row(l_line_tbl(i).order_line_id);

Line 2586: FND_MSG_PUB.Add;

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: */
2590: ELSE

Line 2697: FND_MSG_PUB.ADD;

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);
2701: End loop;

Line 2698: fnd_msg_pub.count_and_get

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);
2701: End loop;
2702: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2768: fnd_msg_pub.count_and_get

2764:
2765: px_header_rec := l_header_rec;
2766: px_line_table := l_line_tbl;
2767:
2768: fnd_msg_pub.count_and_get
2769: ( p_count => x_msg_count
2770: , p_data => x_msg_data);
2771:
2772: END If;

Line 2778: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2774: WHEN FND_API.G_EXC_ERROR THEN
2775: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2776: P_API_NAME => L_API_NAME
2777: ,P_PKG_NAME => G_PKG_NAME
2778: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2779: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2780: ,X_MSG_COUNT => X_MSG_COUNT
2781: ,X_MSG_DATA => X_MSG_DATA
2782: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2787: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2784: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2785: P_API_NAME => L_API_NAME
2786: ,P_PKG_NAME => G_PKG_NAME
2787: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2788: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2789: ,X_MSG_COUNT => X_MSG_COUNT
2790: ,X_MSG_DATA => X_MSG_DATA
2791: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2814: FND_MSG_PUB.ADD;

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);
2818: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2815: fnd_msg_pub.count_and_get

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);
2818: x_return_status := FND_API.G_RET_STS_ERROR;
2819: END;

Line 2909: FND_MSG_PUB.initialize;

2905: SAVEPOINT Process_Order_PUB;
2906:
2907: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
2908: -- initialize message list
2909: FND_MSG_PUB.initialize;
2910: END IF;
2911:
2912: -- Standard call to check for call compatibility.
2913: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 3142: fnd_msg_pub.count_and_get( p_count => x_msg_count

3138: IF (p_commit = FND_API.G_TRUE) THEN
3139: commit;
3140: END IF;
3141:
3142: fnd_msg_pub.count_and_get( p_count => x_msg_count
3143: , p_data => x_msg_data);
3144:
3145: EXCEPTION
3146: WHEN FND_API.G_EXC_ERROR THEN

Line 3150: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3146: WHEN FND_API.G_EXC_ERROR THEN
3147: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3148: P_API_NAME => L_API_NAME
3149: ,P_PKG_NAME => G_PKG_NAME
3150: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3151: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
3152: ,X_MSG_COUNT => X_MSG_COUNT
3153: ,X_MSG_DATA => X_MSG_DATA
3154: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3159: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3156: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3157: P_API_NAME => L_API_NAME
3158: ,P_PKG_NAME => G_PKG_NAME
3159: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3160: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
3161: ,X_MSG_COUNT => X_MSG_COUNT
3162: ,X_MSG_DATA => X_MSG_DATA
3163: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3174: FND_MSG_PUB.ADD;

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);
3178: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3175: fnd_msg_pub.count_and_get

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);
3178: x_return_status := FND_API.G_RET_STS_ERROR;
3179: END;