DBA Data[Home] [Help]

APPS.PA_ACTION_SETS_PUB dependencies on FND_MSG_PUB

Line 59: FND_MSG_PUB.initialize;

55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56:
57: --Clear the global PL/SQL message table
58: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
59: FND_MSG_PUB.initialize;
60: END IF;
61:
62: -- Issue API savepoint if the transaction is to be committed
63: IF p_commit = FND_API.G_TRUE THEN

Line 109: x_msg_count := FND_MSG_PUB.Count_Msg;

105: ,p_attribute15 => p_attribute15
106: ,x_action_set_id => x_action_set_id
107: ,x_return_status => l_return_status);
108:
109: x_msg_count := FND_MSG_PUB.Count_Msg;
110: IF x_msg_count = 1 THEN
111: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
112: ,p_msg_index => 1
113: ,p_data => x_msg_data

Line 138: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Create_Action_Set'

134: ROLLBACK TO CREATE_ACTION_SETS_PUB;
135: END IF;
136:
137: -- Set the excetption Message and the stack
138: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Create_Action_Set'
139: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
140: --
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
142: RAISE;

Line 204: FND_MSG_PUB.initialize;

200: x_return_status := FND_API.G_RET_STS_SUCCESS;
201:
202: --Clear the global PL/SQL message table
203: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
204: FND_MSG_PUB.initialize;
205: END IF;
206:
207: -- Issue API savepoint if the transaction is to be committed
208: IF p_commit = FND_API.G_TRUE THEN

Line 277: x_msg_count := FND_MSG_PUB.Count_Msg;

273: ,p_attribute15 => p_attribute15
274: ,x_return_status => l_return_status);
275:
276:
277: x_msg_count := FND_MSG_PUB.Count_Msg;
278: IF x_msg_count = 1 THEN
279: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
280: ,p_msg_index => 1
281: ,p_data => x_msg_data

Line 306: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Update_Action_Set'

302: ROLLBACK TO UPDATE_ACTION_SETS_PUB;
303: END IF;
304:
305: -- Set the excetption Message and the stack
306: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Update_Action_Set'
307: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
308: --
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: RAISE;

Line 355: FND_MSG_PUB.initialize;

351: x_return_status := FND_API.G_RET_STS_SUCCESS;
352:
353: --Clear the global PL/SQL message table
354: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
355: FND_MSG_PUB.initialize;
356: END IF;
357:
358: -- 5130421
359: l_start_msg_count := FND_MSG_PUB.count_msg ;

Line 359: l_start_msg_count := FND_MSG_PUB.count_msg ;

355: FND_MSG_PUB.initialize;
356: END IF;
357:
358: -- 5130421
359: l_start_msg_count := FND_MSG_PUB.count_msg ;
360:
361: -- Issue API savepoint if the transaction is to be committed
362: IF p_commit = FND_API.G_TRUE THEN
363: SAVEPOINT Delete_ACTION_SETS_PUB;

Line 408: x_msg_count := FND_MSG_PUB.Count_Msg;

404: (p_action_set_id => l_action_set_id
405: ,p_record_version_number => p_record_version_number
406: ,x_return_status => l_return_status);
407:
408: x_msg_count := FND_MSG_PUB.Count_Msg;
409:
410: -- 5130421
411: l_end_msg_count := FND_MSG_PUB.Count_Msg;
412:

Line 411: l_end_msg_count := FND_MSG_PUB.Count_Msg;

407:
408: x_msg_count := FND_MSG_PUB.Count_Msg;
409:
410: -- 5130421
411: l_end_msg_count := FND_MSG_PUB.Count_Msg;
412:
413: l_current_api_msg_count := l_end_msg_count - l_start_msg_count;
414:
415: -- 5130421 IF x_msg_count = 1 THEN

Line 445: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Delete_Action_Set'

441: ROLLBACK TO Delete_ACTION_SETS_PUB;
442: END IF;
443:
444: -- Set the excetption Message and the stack
445: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Delete_Action_Set'
446: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
447: --
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
449: RAISE;

Line 501: FND_MSG_PUB.initialize;

497: x_return_status := FND_API.G_RET_STS_SUCCESS;
498:
499: --Clear the global PL/SQL message table
500: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
501: FND_MSG_PUB.initialize;
502: END IF;
503:
504: -- Issue API savepoint if the transaction is to be committed
505: IF p_commit = FND_API.G_TRUE THEN

Line 540: x_msg_count := FND_MSG_PUB.Count_Msg;

536: ,p_condition_tbl => p_condition_tbl
537: ,x_action_set_line_id => x_action_set_line_id
538: ,x_return_status => l_return_status);
539:
540: x_msg_count := FND_MSG_PUB.Count_Msg;
541: IF x_msg_count = 1 THEN
542: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
543: ,p_msg_index => 1
544: ,p_data => x_msg_data

Line 569: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Create_Action_Set_Line'

565: ROLLBACK TO CREATE_ACTION_SET_LINE_PUB;
566: END IF;
567:
568: -- Set the excetption Message and the stack
569: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Create_Action_Set_Line'
570: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
571: --
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
573: RAISE;

Line 625: FND_MSG_PUB.initialize;

621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622:
623: --Clear the global PL/SQL message table
624: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
625: FND_MSG_PUB.initialize;
626: END IF;
627:
628: -- Issue API savepoint if the transaction is to be committed
629: IF p_commit = FND_API.G_TRUE THEN

Line 663: x_msg_count := FND_MSG_PUB.Count_Msg;

659: ,p_action_attribute10 => p_action_attribute10
660: ,p_condition_tbl => p_condition_tbl
661: ,x_return_status => l_return_status);
662:
663: x_msg_count := FND_MSG_PUB.Count_Msg;
664: IF x_msg_count = 1 THEN
665: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
666: ,p_msg_index => 1
667: ,p_data => x_msg_data

Line 692: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Update_Action_Set_Line'

688: ROLLBACK TO UPDATE_ACTION_SET_LINE_PUB;
689: END IF;
690:
691: -- Set the excetption Message and the stack
692: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Update_Action_Set_Line'
693: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
694: --
695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
696: RAISE;

Line 734: FND_MSG_PUB.initialize;

730: x_return_status := FND_API.G_RET_STS_SUCCESS;
731:
732: --Clear the global PL/SQL message table
733: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
734: FND_MSG_PUB.initialize;
735: END IF;
736:
737: -- Issue API savepoint if the transaction is to be committed
738: IF p_commit = FND_API.G_TRUE THEN

Line 768: x_msg_count := FND_MSG_PUB.Count_Msg;

764: (p_action_set_line_id => p_action_set_line_id
765: ,p_record_version_number => p_record_version_number
766: ,x_return_status => l_return_status);
767:
768: x_msg_count := FND_MSG_PUB.Count_Msg;
769: IF x_msg_count = 1 THEN
770: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
771: ,p_msg_index => 1
772: ,p_data => x_msg_data

Line 797: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Delete_Action_Set_Line'

793: ROLLBACK TO Delete_ACTION_SET_LINE_PUB;
794: END IF;
795:
796: -- Set the excetption Message and the stack
797: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Delete_Action_Set_Line'
798: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
799: --
800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
801: RAISE;

Line 865: FND_MSG_PUB.initialize;

861: x_return_status := FND_API.G_RET_STS_SUCCESS;
862:
863: --Clear the global PL/SQL message table
864: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
865: FND_MSG_PUB.initialize;
866: END IF;
867:
868: -- Issue API savepoint if the transaction is to be committed
869: IF p_commit = FND_API.G_TRUE THEN

Line 880: ,x_msg => 'FND_MSG_PUB.Count_Msg = '||FND_MSG_PUB.Count_Msg

876: ,x_msg => 'Beginning of Apply_Action_Set pub'
877: ,x_log_level => 5);
878:
879: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Apply_Action_Set'
880: ,x_msg => 'FND_MSG_PUB.Count_Msg = '||FND_MSG_PUB.Count_Msg
881: ,x_log_level => 5);
882: END IF;
883:
884: SELECT

Line 998: IF p_perform_action_set_flag = 'Y' AND FND_MSG_PUB.Count_Msg = 0 THEN

994: ,x_return_status => l_return_status
995: ,x_msg_count => l_msg_count
996: ,x_msg_data => l_msg_data);
997:
998: IF p_perform_action_set_flag = 'Y' AND FND_MSG_PUB.Count_Msg = 0 THEN
999:
1000: Perform_Single_Action_Set(p_action_set_id => x_new_action_set_id
1001: ,p_init_msg_list => FND_API.G_FALSE
1002: ,x_return_status => l_return_status

Line 1015: x_msg_count := FND_MSG_PUB.Count_Msg;

1011: ,x_msg => 'calling Perform_Action_Set_Line pub'
1012: ,x_log_level => 5);
1013: END IF;
1014:
1015: x_msg_count := FND_MSG_PUB.Count_Msg;
1016: IF x_msg_count = 1 THEN
1017: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1018: ,p_msg_index => 1
1019: ,p_data => x_msg_data

Line 1044: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Apply_Action_Set'

1040: ROLLBACK TO APPLY_ACTION_SET_PUB;
1041: END IF;
1042:
1043: -- Set the excetption Message and the stack
1044: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Apply_Action_Set'
1045: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1046: --
1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1048: RAISE;

Line 1093: FND_MSG_PUB.initialize;

1089: x_return_status := FND_API.G_RET_STS_SUCCESS;
1090:
1091: --Clear the global PL/SQL message table
1092: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1093: FND_MSG_PUB.initialize;
1094: END IF;
1095:
1096: -- Issue API savepoint if the transaction is to be committed
1097: IF p_commit = FND_API.G_TRUE THEN

Line 1126: IF FND_MSG_PUB.Count_Msg = 0 THEN

1122: ,x_return_status => l_return_status
1123: ,x_msg_count => l_msg_count
1124: ,x_msg_data => l_msg_data);
1125:
1126: IF FND_MSG_PUB.Count_Msg = 0 THEN
1127:
1128: --Log Message: 4370082
1129: IF l_debug_mode = 'Y' THEN
1130: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Replace_Action_Set.begin'

Line 1147: x_msg_count := FND_MSG_PUB.Count_Msg;

1143:
1144: END IF;
1145:
1146:
1147: x_msg_count := FND_MSG_PUB.Count_Msg;
1148: IF x_msg_count = 1 THEN
1149: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1150: ,p_msg_index => 1
1151: ,p_data => x_msg_data

Line 1172: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'

1168:
1169: EXCEPTION
1170: WHEN e_invalid_result_code THEN
1171: /*
1172: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'
1173: ,p_procedure_name => 'INVALID RESULTS CODE: '||l_action_line_result_code);
1174: --
1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1176: */

Line 1184: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Replace_Action_Set'

1180: ROLLBACK TO REPLACE_ACTION_SET;
1181: END IF;
1182:
1183: -- Set the excetption Message and the stack
1184: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Replace_Action_Set'
1185: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1186: --
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1188: RAISE;

Line 1245: FND_MSG_PUB.initialize;

1241: x_return_status := FND_API.G_RET_STS_SUCCESS;
1242:
1243: --Clear the global PL/SQL message table
1244: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1245: FND_MSG_PUB.initialize;
1246: END IF;
1247:
1248: -- Issue API savepoint if the transaction is to be committed
1249: IF p_commit = FND_API.G_TRUE THEN

Line 1295: FND_MSG_PUB.initialize;

1291: IF l_action_set_line_id_tbl.COUNT > 0 THEN
1292:
1293: FOR i IN l_action_set_line_id_tbl.FIRST .. l_action_set_line_id_tbl.LAST LOOP
1294:
1295: FND_MSG_PUB.initialize;
1296:
1297: PA_ACTION_SETS_PVT.Perform_Action_Set_Line(p_action_set_type_code => l_action_set_type_code ,
1298: p_action_set_line_id => l_action_set_line_id_tbl(i)
1299: ,x_return_status => l_return_status);

Line 1305: FND_MSG_PUB.initialize;

1301: END LOOP;
1302:
1303: -- 2452311: Need to initialize the error stack after performing the last
1304: -- action set line.
1305: FND_MSG_PUB.initialize;
1306:
1307: END IF;
1308:
1309: x_msg_count := FND_MSG_PUB.Count_Msg;

Line 1309: x_msg_count := FND_MSG_PUB.Count_Msg;

1305: FND_MSG_PUB.initialize;
1306:
1307: END IF;
1308:
1309: x_msg_count := FND_MSG_PUB.Count_Msg;
1310: IF x_msg_count = 1 THEN
1311: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1312: ,p_msg_index => 1
1313: ,p_data => x_msg_data

Line 1338: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Perform_Single_Action_Set'

1334: ROLLBACK TO PERFORM_SINGLE_ACTION_SET;
1335: END IF;
1336:
1337: -- Set the excetption Message and the stack
1338: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Perform_Single_Action_Set'
1339: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1340: --
1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1342: RAISE;

Line 1423: FND_MSG_PUB.initialize;

1419: l_object_name_tbl(k));
1420:
1421: FOR j IN l_action_set_line_id_tbl.FIRST .. l_action_set_line_id_tbl.LAST LOOP
1422:
1423: FND_MSG_PUB.initialize;
1424:
1425: IF p_debug_mode = 'Y' THEN
1426: FND_FILE.PUT_LINE(FND_FILE.LOG, 'About to perform action set line id '||l_action_set_line_id_tbl(j));
1427: END IF;

Line 1450: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'

1446:
1447: EXCEPTION
1448: WHEN e_invalid_result_code THEN
1449: /*
1450: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'
1451: ,p_procedure_name => 'INVALID RESULTS CODE: '||l_action_line_result_code);
1452: --
1453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1454: */

Line 1459: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'

1455: RAISE;
1456:
1457: WHEN OTHERS THEN
1458: -- Set the excetption Message and the stack
1459: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'
1460: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1461: --
1462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1463: RAISE;

Line 1578: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.create_line_single_cond'

1574: EXCEPTION
1575: WHEN OTHERS THEN
1576:
1577: -- Set the excetption Message and the stack
1578: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.create_line_single_cond'
1579: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1580: --
1581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1582: RAISE;

Line 1698: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.update_line_single_cond'

1694: EXCEPTION
1695: WHEN OTHERS THEN
1696:
1697: -- Set the excetption Message and the stack
1698: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.update_line_single_cond'
1699: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1700: --
1701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1702: RAISE;

Line 1723: FND_MSG_PUB.initialize;

1719:
1720: -- Initialize the return status to success
1721: x_return_status := FND_API.G_RET_STS_SUCCESS;
1722:
1723: FND_MSG_PUB.initialize;
1724:
1725: SELECT action_set_template_flag, action_set_type_code INTO l_action_set_template_flag, l_action_set_type_code
1726: FROM pa_action_sets
1727: WHERE action_set_id = p_action_set_id;

Line 1734: x_msg_count := FND_MSG_PUB.Count_Msg;

1730: p_action_set_id => p_action_set_id,
1731: p_action_set_template_flag => l_action_set_template_flag,
1732: x_return_status => l_return_status);
1733:
1734: x_msg_count := FND_MSG_PUB.Count_Msg;
1735: IF x_msg_count = 1 THEN
1736: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1737: ,p_msg_index => 1
1738: ,p_data => x_msg_data

Line 1754: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Validate_Action_Set'

1750:
1751: EXCEPTION
1752: WHEN OTHERS THEN
1753: -- Set the excetption Message and the stack
1754: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Validate_Action_Set'
1755: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1756: --
1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1758: RAISE;