DBA Data[Home] [Help]

APPS.PA_PROJ_TEMPLATE_SETUP_PUB dependencies on FND_MSG_PUB

Line 82: FND_MSG_PUB.initialize;

78: END IF;
79:
80:
81: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
82: FND_MSG_PUB.initialize;
83: END IF;
84:
85: IF (p_calling_module = 'SELF_SERVICE') OR (p_calling_module = 'EXCHANGE') THEN
86: --Check Carrying out organization name and Carrying out organization Id

Line 131: x_msg_count := FND_MSG_PUB.count_msg;

127: END IF; --End Name-Id Conversion
128: END IF;
129:
130: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
131: x_msg_count := FND_MSG_PUB.count_msg;
132: IF x_msg_count = 1 then
133: pa_interface_utils_pub.get_messages
134: (p_encoded => FND_API.G_TRUE,
135: p_msg_index => 1,

Line 175: x_msg_count := FND_MSG_PUB.count_msg;

171: ,x_msg_count => l_msg_count
172: ,x_msg_data => l_msg_data );
173:
174: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
175: x_msg_count := FND_MSG_PUB.count_msg;
176: IF x_msg_count = 1 then
177: pa_interface_utils_pub.get_messages
178: (p_encoded => FND_API.G_TRUE,
179: p_msg_index => 1,

Line 209: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

205: if p_commit = FND_API.G_TRUE then
206: rollback to Create_Project_Template;
207: end if;
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
210: p_procedure_name => 'Create_Project_Template',
211: p_error_text => SUBSTRB(SQLERRM,1,240));
212: when OTHERS then
213: if p_commit = FND_API.G_TRUE then

Line 217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

213: if p_commit = FND_API.G_TRUE then
214: rollback to Create_Project_Template;
215: end if;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
218: p_procedure_name => 'Create_Project_Template',
219: p_error_text => SUBSTRB(SQLERRM,1,240));
220: raise;
221: END Create_Project_Template;

Line 306: FND_MSG_PUB.initialize;

302: END IF;
303:
304:
305: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
306: FND_MSG_PUB.initialize;
307: END IF;
308:
309: IF (p_calling_module = 'SELF_SERVICE') OR (p_calling_module = 'EXCHANGE') THEN
310: --Check Carrying out organization name and Carrying out organization Id

Line 353: x_msg_count := FND_MSG_PUB.count_msg;

349: END IF; --End Name-Id Conversion
350: END IF;
351:
352: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
353: x_msg_count := FND_MSG_PUB.count_msg;
354: IF x_msg_count = 1 then
355: pa_interface_utils_pub.get_messages
356: (p_encoded => FND_API.G_TRUE,
357: p_msg_index => 1,

Line 429: l_msg_count := FND_MSG_PUB.count_msg;

425: x_return_status := 'E' ;
426: END IF;
427: END;
428: end if;
429: l_msg_count := FND_MSG_PUB.count_msg;
430:
431: IF l_msg_count > 0 THEN
432: x_msg_count := l_msg_count;
433: x_return_status := 'E';

Line 467: x_msg_count := FND_MSG_PUB.count_msg;

463: ,x_msg_count => l_msg_count
464: ,x_msg_data => l_msg_data );
465:
466: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
467: x_msg_count := FND_MSG_PUB.count_msg;
468: IF x_msg_count = 1 then
469: pa_interface_utils_pub.get_messages
470: (p_encoded => FND_API.G_TRUE,
471: p_msg_index => 1,

Line 501: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

497: if p_commit = FND_API.G_TRUE then
498: rollback to Update_Project_Template;
499: end if;
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
501: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
502: p_procedure_name => 'Update_Project_Template',
503: p_error_text => SUBSTRB(SQLERRM,1,240));
504: when OTHERS then
505: if p_commit = FND_API.G_TRUE then

Line 509: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

505: if p_commit = FND_API.G_TRUE then
506: rollback to Update_Project_Template;
507: end if;
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
510: p_procedure_name => 'Update_Project_Template',
511: p_error_text => SUBSTRB(SQLERRM,1,240));
512: raise;
513: END Update_Project_Template;

Line 573: FND_MSG_PUB.initialize;

569: END IF;
570:
571:
572: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
573: FND_MSG_PUB.initialize;
574: END IF;
575:
576: IF p_validate_only <> FND_API.G_TRUE
577: THEN

Line 638: l_msg_count := FND_MSG_PUB.count_msg;

634: x_return_status := 'E' ;
635: END IF;
636: END;
637: end if;
638: l_msg_count := FND_MSG_PUB.count_msg;
639:
640: IF l_msg_count > 0 THEN
641: x_msg_count := l_msg_count;
642: x_return_status := 'E';

Line 662: x_msg_count := FND_MSG_PUB.count_msg;

658: ,x_msg_count => l_msg_count
659: ,x_msg_data => l_msg_data );
660:
661: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
662: x_msg_count := FND_MSG_PUB.count_msg;
663: IF x_msg_count = 1 then
664: pa_interface_utils_pub.get_messages
665: (p_encoded => FND_API.G_TRUE,
666: p_msg_index => 1,

Line 696: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

692: if p_commit = FND_API.G_TRUE then
693: rollback to Delete_Project_Template;
694: end if;
695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
696: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
697: p_procedure_name => 'Delete_Project_Template',
698: p_error_text => SUBSTRB(SQLERRM,1,240));
699: when OTHERS then
700: if p_commit = FND_API.G_TRUE then

Line 704: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

700: if p_commit = FND_API.G_TRUE then
701: rollback to Delete_Project_Template;
702: end if;
703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
704: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
705: p_procedure_name => 'Delete_Project_Template',
706: p_error_text => SUBSTRB(SQLERRM,1,240));
707: raise;
708: END Delete_Project_Template;

Line 769: FND_MSG_PUB.initialize;

765: END IF;
766:
767:
768: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
769: FND_MSG_PUB.initialize;
770: END IF;
771:
772: PA_PROJ_TEMPLATE_SETUP_PVT.Add_Project_Options(
773: p_api_version => p_api_version

Line 789: x_msg_count := FND_MSG_PUB.count_msg;

785: ,x_msg_count => l_msg_count
786: ,x_msg_data => l_msg_data );
787:
788: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
789: x_msg_count := FND_MSG_PUB.count_msg;
790: IF x_msg_count = 1 then
791: pa_interface_utils_pub.get_messages
792: (p_encoded => FND_API.G_TRUE,
793: p_msg_index => 1,

Line 823: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

819: if p_commit = FND_API.G_TRUE then
820: rollback to Add_Project_Options;
821: end if;
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
823: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
824: p_procedure_name => 'Add_Project_Options',
825: p_error_text => SUBSTRB(SQLERRM,1,240));
826: when OTHERS then
827: if p_commit = FND_API.G_TRUE then

Line 831: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

827: if p_commit = FND_API.G_TRUE then
828: rollback to Add_Project_Options;
829: end if;
830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
831: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
832: p_procedure_name => 'Add_Project_Options',
833: p_error_text => SUBSTRB(SQLERRM,1,240));
834: raise;
835: END Add_Project_Options;

Line 897: FND_MSG_PUB.initialize;

893: END IF;
894:
895:
896: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
897: FND_MSG_PUB.initialize;
898: END IF;
899:
900: PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Options(
901: p_api_version => p_api_version

Line 916: x_msg_count := FND_MSG_PUB.count_msg;

912: ,x_msg_count => l_msg_count
913: ,x_msg_data => l_msg_data );
914:
915: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
916: x_msg_count := FND_MSG_PUB.count_msg;
917: IF x_msg_count = 1 then
918: pa_interface_utils_pub.get_messages
919: (p_encoded => FND_API.G_TRUE,
920: p_msg_index => 1,

Line 950: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

946: if p_commit = FND_API.G_TRUE then
947: rollback to Delete_Project_Options;
948: end if;
949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
950: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
951: p_procedure_name => 'Delete_Project_Options',
952: p_error_text => SUBSTRB(SQLERRM,1,240));
953: when OTHERS then
954: if p_commit = FND_API.G_TRUE then

Line 958: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

954: if p_commit = FND_API.G_TRUE then
955: rollback to Delete_Project_Options;
956: end if;
957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
958: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
959: p_procedure_name => 'Delete_Project_Options',
960: p_error_text => SUBSTRB(SQLERRM,1,240));
961: raise;
962: END Delete_Project_Options;

Line 1032: FND_MSG_PUB.initialize;

1028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1029: END IF;
1030:
1031: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1032: FND_MSG_PUB.initialize;
1033: END IF;
1034:
1035: IF p_sort_order IS NULL
1036: THEN

Line 1097: x_msg_count := FND_MSG_PUB.count_msg;

1093: l_limiting_value := null;
1094: END IF;
1095:
1096: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1097: x_msg_count := FND_MSG_PUB.count_msg;
1098: IF x_msg_count = 1 then
1099: pa_interface_utils_pub.get_messages
1100: (p_encoded => FND_API.G_TRUE,
1101: p_msg_index => 1,

Line 1131: x_msg_count := FND_MSG_PUB.count_msg;

1127: ,x_msg_count => l_msg_count
1128: ,x_msg_data => l_msg_data );
1129:
1130: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1131: x_msg_count := FND_MSG_PUB.count_msg;
1132: IF x_msg_count = 1 then
1133: pa_interface_utils_pub.get_messages
1134: (p_encoded => FND_API.G_TRUE,
1135: p_msg_index => 1,

Line 1165: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

1161: if p_commit = FND_API.G_TRUE then
1162: rollback to Add_Quick_Entry_Field;
1163: end if;
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1165: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
1166: p_procedure_name => 'Add_Quick_Entry_Field',
1167: p_error_text => SUBSTRB(SQLERRM,1,240));
1168: when OTHERS then
1169: if p_commit = FND_API.G_TRUE then

Line 1173: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

1169: if p_commit = FND_API.G_TRUE then
1170: rollback to Add_Quick_Entry_Field;
1171: end if;
1172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1173: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
1174: p_procedure_name => 'Add_Quick_Entry_Field',
1175: p_error_text => SUBSTRB(SQLERRM,1,240));
1176: raise;
1177: END Add_Quick_Entry_Field;

Line 1259: FND_MSG_PUB.initialize;

1255: END IF;
1256:
1257:
1258: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1259: FND_MSG_PUB.initialize;
1260: END IF;
1261:
1262: IF p_sort_order IS NULL
1263: THEN

Line 1338: x_msg_count := FND_MSG_PUB.count_msg;

1334: l_limiting_value := null;
1335: END IF;
1336:
1337: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1338: x_msg_count := FND_MSG_PUB.count_msg;
1339: IF x_msg_count = 1 then
1340: pa_interface_utils_pub.get_messages
1341: (p_encoded => FND_API.G_TRUE,
1342: p_msg_index => 1,

Line 1416: l_msg_count := FND_MSG_PUB.count_msg;

1412: x_return_status := 'E' ;
1413: END IF;
1414: END;
1415: end if;
1416: l_msg_count := FND_MSG_PUB.count_msg;
1417:
1418: IF l_msg_count > 0 THEN
1419: x_msg_count := l_msg_count;
1420: x_return_status := 'E';

Line 1446: x_msg_count := FND_MSG_PUB.count_msg;

1442: ,x_msg_count => l_msg_count
1443: ,x_msg_data => l_msg_data );
1444:
1445: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1446: x_msg_count := FND_MSG_PUB.count_msg;
1447: IF x_msg_count = 1 then
1448: pa_interface_utils_pub.get_messages
1449: (p_encoded => FND_API.G_TRUE,
1450: p_msg_index => 1,

Line 1480: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

1476: if p_commit = FND_API.G_TRUE then
1477: rollback to Update_Quick_Entry_Field;
1478: end if;
1479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1480: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
1481: p_procedure_name => 'Update_Quick_Entry_Field',
1482: p_error_text => SUBSTRB(SQLERRM,1,240));
1483: when OTHERS then
1484: if p_commit = FND_API.G_TRUE then

Line 1488: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

1484: if p_commit = FND_API.G_TRUE then
1485: rollback to Update_Quick_Entry_Field;
1486: end if;
1487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1488: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
1489: p_procedure_name => 'Update_Quick_Entry_Field',
1490: p_error_text => SUBSTRB(SQLERRM,1,240));
1491: raise;
1492: END Update_Quick_Entry_Field;

Line 1556: FND_MSG_PUB.initialize;

1552: END IF;
1553:
1554:
1555: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1556: FND_MSG_PUB.initialize;
1557: END IF;
1558:
1559: IF p_validate_only <> FND_API.G_TRUE
1560: THEN

Line 1623: l_msg_count := FND_MSG_PUB.count_msg;

1619: x_return_status := 'E' ;
1620: END IF;
1621: END;
1622: end if;
1623: l_msg_count := FND_MSG_PUB.count_msg;
1624:
1625: IF l_msg_count > 0 THEN
1626: x_msg_count := l_msg_count;
1627: x_return_status := 'E';

Line 1648: x_msg_count := FND_MSG_PUB.count_msg;

1644: ,x_msg_count => l_msg_count
1645: ,x_msg_data => l_msg_data );
1646:
1647: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1648: x_msg_count := FND_MSG_PUB.count_msg;
1649: IF x_msg_count = 1 then
1650: pa_interface_utils_pub.get_messages
1651: (p_encoded => FND_API.G_TRUE,
1652: p_msg_index => 1,

Line 1682: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

1678: if p_commit = FND_API.G_TRUE then
1679: rollback to Delete_Quick_Entry_Field;
1680: end if;
1681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1682: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
1683: p_procedure_name => 'Delete_Quick_Entry_Field',
1684: p_error_text => SUBSTRB(SQLERRM,1,240));
1685: when OTHERS then
1686: if p_commit = FND_API.G_TRUE then

Line 1690: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

1686: if p_commit = FND_API.G_TRUE then
1687: rollback to Delete_Quick_Entry_Field;
1688: end if;
1689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1690: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
1691: p_procedure_name => 'Delete_Quick_Entry_Field',
1692: p_error_text => SUBSTRB(SQLERRM,1,240));
1693: raise;
1694: END Delete_Quick_Entry_Field;