DBA Data[Home] [Help]

APPS.PA_RELATIONSHIP_PUB dependencies on FND_MSG_PUB

Line 131: FND_MSG_PUB.initialize;

127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129:
130: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
131: FND_MSG_PUB.initialize;
132: END IF;
133:
134:
135: --name to id conversion

Line 287: x_msg_count := FND_MSG_PUB.count_msg;

283: PA_UTILS.ADD_MESSAGE( 'PA', l_error_msg_code);
284: END IF;
285: END IF;
286:
287: x_msg_count := FND_MSG_PUB.count_msg;
288: IF x_msg_count > 0 THEN
289: If x_msg_count > 1 then
290: pa_interface_utils_pub.get_messages
291: (p_encoded => FND_API.G_TRUE,

Line 335: x_msg_count := FND_MSG_PUB.count_msg;

331: ,x_msg_data => l_msg_data
332: );
333:
334: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
335: x_msg_count := FND_MSG_PUB.count_msg;
336: IF x_msg_count = 1 then
337: pa_interface_utils_pub.get_messages
338: (p_encoded => FND_API.G_TRUE,
339: p_msg_index => 1,

Line 371: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

367: if p_commit = FND_API.G_TRUE then
368: rollback to create_relationship;
369: end if;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
372: p_procedure_name => 'CREATE_RELATIONSHIP',
373: p_error_text => SUBSTRB(SQLERRM,1,240));
374: when OTHERS then
375: if p_commit = FND_API.G_TRUE then

Line 379: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',

375: if p_commit = FND_API.G_TRUE then
376: rollback to create_relationship;
377: end if;
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',
380: p_procedure_name => 'CREATE_RELATIONSHIP',
381: p_error_text => SUBSTRB(SQLERRM,1,240));
382: raise;
383: END CREATE_RELATIONSHIP;

Line 456: FND_MSG_PUB.initialize;

452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;
454:
455: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
456: FND_MSG_PUB.initialize;
457: END IF;
458:
459: PA_RELATIONSHIP_PVT.Delete_Relationship(
460: p_api_version => p_api_version

Line 476: x_msg_count := FND_MSG_PUB.count_msg;

472: ,x_msg_data => l_msg_data
473: );
474:
475: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
476: x_msg_count := FND_MSG_PUB.count_msg;
477: IF x_msg_count = 1 then
478: pa_interface_utils_pub.get_messages
479: (p_encoded => FND_API.G_TRUE,
480: p_msg_index => 1,

Line 503: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

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

Line 511: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',

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

Line 620: FND_MSG_PUB.initialize;

616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
617: END IF;
618:
619: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
620: FND_MSG_PUB.initialize;
621: END IF;
622:
623: IF p_src_proj_id IS NULL
624: THEN

Line 707: x_msg_count := FND_MSG_PUB.count_msg;

703: RAISE FND_API.G_EXC_ERROR;
704: END IF;
705:
706: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
707: x_msg_count := FND_MSG_PUB.count_msg;
708: IF x_msg_count = 1 then
709: pa_interface_utils_pub.get_messages
710: (p_encoded => FND_API.G_TRUE,
711: p_msg_index => 1,

Line 746: x_msg_count := FND_MSG_PUB.count_msg;

742: ,x_msg_data => l_msg_data
743: );
744:
745: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
746: x_msg_count := FND_MSG_PUB.count_msg;
747: IF x_msg_count = 1 then
748: pa_interface_utils_pub.get_messages
749: (p_encoded => FND_API.G_TRUE,
750: p_msg_index => 1,

Line 781: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

777: if p_commit = FND_API.G_TRUE then
778: rollback to create_dependency;
779: end if;
780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
781: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
782: p_procedure_name => 'CREATE_DEPENDENCY',
783: p_error_text => SUBSTRB(SQLERRM,1,240));
784: when OTHERS then
785: if p_commit = FND_API.G_TRUE then

Line 789: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',

785: if p_commit = FND_API.G_TRUE then
786: rollback to create_dependency;
787: end if;
788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
789: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',
790: p_procedure_name => 'CREATE_DEPENDENCY',
791: p_error_text => SUBSTRB(SQLERRM,1,240));
792: raise;
793: END Create_Dependency;

Line 870: FND_MSG_PUB.initialize;

866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
867: END IF;
868:
869: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
870: FND_MSG_PUB.initialize;
871: END IF;
872:
873: --Call private update dependency API here.
874: PA_RELATIONSHIP_PVT.Update_Dependency

Line 896: x_msg_count := FND_MSG_PUB.count_msg;

892: ,x_msg_data => l_msg_data
893: );
894:
895: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
896: x_msg_count := FND_MSG_PUB.count_msg;
897: IF x_msg_count = 1 then
898: pa_interface_utils_pub.get_messages
899: (p_encoded => FND_API.G_TRUE,
900: p_msg_index => 1,

Line 931: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

927: if p_commit = FND_API.G_TRUE then
928: rollback to update_dependency;
929: end if;
930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
931: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
932: p_procedure_name => 'UPDATE_DEPENDENCY',
933: p_error_text => SUBSTRB(SQLERRM,1,240));
934: when OTHERS then
935: if p_commit = FND_API.G_TRUE then

Line 939: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',

935: if p_commit = FND_API.G_TRUE then
936: rollback to update_dependency;
937: end if;
938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
939: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',
940: p_procedure_name => 'UPDATE_DEPENDENCY',
941: p_error_text => SUBSTRB(SQLERRM,1,240));
942: raise;
943: END Update_Dependency;

Line 1011: FND_MSG_PUB.initialize;

1007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1008: END IF;
1009:
1010: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1011: FND_MSG_PUB.initialize;
1012: END IF;
1013:
1014: --Call private delete dependency API here.
1015:

Line 1033: x_msg_count := FND_MSG_PUB.count_msg;

1029: ,x_msg_data => l_msg_data
1030: );
1031:
1032: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1033: x_msg_count := FND_MSG_PUB.count_msg;
1034: IF x_msg_count = 1 then
1035: pa_interface_utils_pub.get_messages
1036: (p_encoded => FND_API.G_TRUE,
1037: p_msg_index => 1,

Line 1067: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

1063: if p_commit = FND_API.G_TRUE then
1064: rollback to delete_dependency;
1065: end if;
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
1068: p_procedure_name => 'DELETE_DEPENDENCY',
1069: p_error_text => SUBSTRB(SQLERRM,1,240));
1070: when OTHERS then
1071: if p_commit = FND_API.G_TRUE then

Line 1075: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',

1071: if p_commit = FND_API.G_TRUE then
1072: rollback to delete_dependency;
1073: end if;
1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1075: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',
1076: p_procedure_name => 'DELETE_DEPENDENCY',
1077: p_error_text => SUBSTRB(SQLERRM,1,240));
1078: raise;
1079: END Delete_Dependency;

Line 1165: FND_MSG_PUB.initialize;

1161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1162: END IF;
1163: --
1164: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1165: FND_MSG_PUB.initialize;
1166: END IF;
1167: --
1168: --
1169: -- For destination Project

Line 1210: x_msg_count := FND_MSG_PUB.count_msg;

1206: x_return_status => l_return_status,
1207: x_msg_count => x_msg_count,
1208: x_msg_data => x_msg_data);
1209: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1210: x_msg_count := FND_MSG_PUB.count_msg;
1211: IF x_msg_count = 1 then
1212: pa_interface_utils_pub.get_messages
1213: (p_encoded => FND_API.G_TRUE,
1214: p_msg_index => 1,

Line 1245: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

1241: if p_commit = FND_API.G_TRUE then
1242: rollback to create_subproject_association;
1243: end if;
1244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1245: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
1246: p_procedure_name => 'CREATE_SUBPROJECT_ASSOCIATION',
1247: p_error_text => SUBSTRB(SQLERRM,1,240));
1248: when OTHERS then
1249: if p_commit = FND_API.G_TRUE then

Line 1253: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',

1249: if p_commit = FND_API.G_TRUE then
1250: rollback to create_subproject_association;
1251: end if;
1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1253: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',
1254: p_procedure_name => 'CREATE_SUBPROJECT_ASSOCIATION',
1255: p_error_text => SUBSTRB(SQLERRM,1,240));
1256: raise;
1257: END create_subproject_association;

Line 1334: FND_MSG_PUB.initialize;

1330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1331: END IF;
1332: --
1333: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1334: FND_MSG_PUB.initialize;
1335: END IF;
1336: --
1337: --
1338: PA_RELATIONSHIP_PVT.Update_Subproject_Association

Line 1354: x_msg_count := FND_MSG_PUB.count_msg;

1350: x_return_status => l_return_status,
1351: x_msg_count => x_msg_count,
1352: x_msg_data => x_msg_data);
1353: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1354: x_msg_count := FND_MSG_PUB.count_msg;
1355: IF x_msg_count = 1 then
1356: pa_interface_utils_pub.get_messages
1357: (p_encoded => FND_API.G_TRUE,
1358: p_msg_index => 1,

Line 1389: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

1385: if p_commit = FND_API.G_TRUE then
1386: rollback to Update_Subproject_Association;
1387: end if;
1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1389: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
1390: p_procedure_name => 'UPDATE_SUBPROJECT_ASSOCIATION',
1391: p_error_text => SUBSTRB(SQLERRM,1,240));
1392: when OTHERS then
1393: if p_commit = FND_API.G_TRUE then

Line 1397: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',

1393: if p_commit = FND_API.G_TRUE then
1394: rollback to Update_Subproject_Association;
1395: end if;
1396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1397: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',
1398: p_procedure_name => 'UPDATE_SUBPROJECT_ASSOCIATION',
1399: p_error_text => SUBSTRB(SQLERRM,1,240));
1400: raise;
1401: END Update_Subproject_Association;

Line 1474: FND_MSG_PUB.initialize;

1470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1471: END IF;
1472: --
1473: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1474: FND_MSG_PUB.initialize;
1475: END IF;
1476: --
1477: --
1478: PA_RELATIONSHIP_PVT.Delete_SubProject_Association(

Line 1491: x_msg_count := FND_MSG_PUB.count_msg;

1487: x_return_status => l_return_status,
1488: x_msg_count => x_msg_count,
1489: x_msg_data => x_msg_data);
1490: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1491: x_msg_count := FND_MSG_PUB.count_msg;
1492: IF x_msg_count = 1 then
1493: pa_interface_utils_pub.get_messages
1494: (p_encoded => FND_API.G_TRUE,
1495: p_msg_index => 1,

Line 1526: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

1522: if p_commit = FND_API.G_TRUE then
1523: rollback to Delete_SubProject_Association;
1524: end if;
1525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1526: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
1527: p_procedure_name => 'DELETE_SUBPROJECT_ASSOCIATION',
1528: p_error_text => SUBSTRB(SQLERRM,1,240));
1529: when OTHERS then
1530: if p_commit = FND_API.G_TRUE then

Line 1534: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',

1530: if p_commit = FND_API.G_TRUE then
1531: rollback to Delete_SubProject_Association;
1532: end if;
1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1534: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',
1535: p_procedure_name => 'DELETE_SUBPROJECT_ASSOCIATION',
1536: p_error_text => SUBSTRB(SQLERRM,1,240));
1537: raise;
1538: END Delete_SubProject_Association;