DBA Data[Home] [Help]

APPS.PA_PROJ_STRUCTURE_PUB dependencies on FND_MSG_PUB

Line 48: FND_MSG_PUB.add_exc_msg(

44: When OTHERS Then
45: IF (p_commit = FND_API.G_TRUE) THEN
46: ROLLBACK TO CREATE_TASK_PROJ_REL;
47: END IF;
48: FND_MSG_PUB.add_exc_msg(
49: p_pkg_name => 'CREATE_RELATIONSHIP',
50: p_procedure_name => PA_DEBUG.G_Err_Stack
51: );
52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 70: FND_MSG_PUB.add_exc_msg(

66:
67: return PA_PROJ_STRUCTURE_UTILS.CHECK_PROJECT_CONTRACT_EXISTS(p_project_id);
68: EXCEPTION
69: WHEN OTHERS THEN
70: FND_MSG_PUB.add_exc_msg(
71: p_pkg_name => 'CHECK_SUBPROJ_CONTRACT_ASSO',
72: p_procedure_name => PA_DEBUG.G_Err_Stack
73: );
74: RAISE;

Line 91: FND_MSG_PUB.add_exc_msg(

87:
88: return PA_PROJ_STRUCTURE_UTILS.CHECK_TASK_CONTRACT_EXISTS(p_task_id);
89: EXCEPTION
90: WHEN OTHERS THEN
91: FND_MSG_PUB.add_exc_msg(
92: p_pkg_name => 'CHECK_TASK_CONTRACT_ASSO',
93: p_procedure_name => PA_DEBUG.G_Err_Stack
94: );
95: RAISE;

Line 137: FND_MSG_PUB.add_exc_msg(

133: When OTHERS Then
134: IF (p_commit = FND_API.G_TRUE) THEN
135: ROLLBACK TO DELETE_TASK_PROJ_REL;
136: END IF;
137: FND_MSG_PUB.add_exc_msg(
138: p_pkg_name => 'DELETE_RELATIONSHIP',
139: p_procedure_name => PA_DEBUG.G_Err_Stack
140: );
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 223: FND_MSG_PUB.initialize;

219: END IF;
220:
221:
222: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
223: FND_MSG_PUB.initialize;
224: END IF;
225:
226:
227: IF g1_debug_mode = 'Y' THEN

Line 589: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

585: x_msg_count := 1;
586: x_msg_data := SQLERRM;
587:
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
590: p_procedure_name => 'POPULATE_STRUCTURES_TMP_TAB',
591: p_error_text => SUBSTRB(SQLERRM,1,240));
592: when OTHERS then
593: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 597: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

593: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
594: x_msg_count := 1;
595: x_msg_data := SUBSTRB(SQLERRM,1,240);
596:
597: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
598: p_procedure_name => 'POPULATE_STRUCTURES_TMP_TAB',
599: p_error_text => SUBSTRB(SQLERRM,1,240));
600: raise;
601:

Line 721: FND_MSG_PUB.initialize;

717: END IF;
718:
719:
720: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
721: FND_MSG_PUB.initialize;
722: END IF;
723:
724:
725: IF g1_debug_mode = 'Y' THEN

Line 3326: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

3322: x_msg_count := 1;
3323: x_msg_data := SQLERRM;
3324:
3325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3326: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
3327: p_procedure_name => 'INSERT_PUBLISHED_RECORDS',
3328: p_error_text => SUBSTRB(SQLERRM,1,240));
3329: when OTHERS then
3330: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 3334: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

3330: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3331: x_msg_count := 1;
3332: x_msg_data := SUBSTRB(SQLERRM,1,240);
3333:
3334: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
3335: p_procedure_name => 'INSERT_PUBLISHED_RECORDS',
3336: p_error_text => SUBSTRB(SQLERRM,1,240));
3337: raise;
3338: END INSERT_PUBLISHED_RECORDS;

Line 3400: FND_MSG_PUB.initialize;

3396: END IF;
3397:
3398:
3399: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
3400: FND_MSG_PUB.initialize;
3401: END IF;
3402:
3403:
3404: IF g1_debug_mode = 'Y' THEN

Line 5932: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

5928: x_msg_count := 1;
5929: x_msg_data := SQLERRM;
5930:
5931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5932: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
5933: p_procedure_name => 'INSERT_WORKING_RECORDS',
5934: p_error_text => SUBSTRB(SQLERRM,1,240));
5935: when OTHERS then
5936: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 5940: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

5936: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5937: x_msg_count := 1;
5938: x_msg_data := SUBSTRB(SQLERRM,1,240);
5939:
5940: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
5941: p_procedure_name => 'INSERT_WORKING_RECORDS',
5942: p_error_text => SUBSTRB(SQLERRM,1,240));
5943: raise;
5944: END INSERT_WORKING_RECORDS;

Line 6039: FND_MSG_PUB.initialize;

6035: END IF;
6036:
6037:
6038: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
6039: FND_MSG_PUB.initialize;
6040: END IF;
6041:
6042:
6043: IF g1_debug_mode = 'Y' THEN

Line 7398: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

7394: x_msg_count := 1;
7395: x_msg_data := SQLERRM;
7396:
7397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7398: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
7399: p_procedure_name => 'INSERT_SUBPROJECTS',
7400: p_error_text => SUBSTRB(SQLERRM,1,240));
7401: when OTHERS then
7402: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 7406: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

7402: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7403: x_msg_count := 1;
7404: x_msg_data := SUBSTRB(SQLERRM,1,240);
7405:
7406: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
7407: p_procedure_name => 'INSERT_SUBPROJECTS',
7408: p_error_text => SUBSTRB(SQLERRM,1,240));
7409: raise;
7410: END INSERT_SUBPROJECTS;

Line 7469: FND_MSG_PUB.initialize;

7465: END IF;
7466:
7467:
7468: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
7469: FND_MSG_PUB.initialize;
7470: END IF;
7471:
7472:
7473: IF g1_debug_mode = 'Y' THEN

Line 8162: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

8158: x_msg_count := 1;
8159: x_msg_data := SQLERRM;
8160:
8161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8162: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
8163: p_procedure_name => 'INSERT_PUBLISHED_RECORD',
8164: p_error_text => SUBSTRB(SQLERRM,1,240));
8165: when OTHERS then
8166: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 8170: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

8166: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
8167: x_msg_count := 1;
8168: x_msg_data := SUBSTRB(SQLERRM,1,240);
8169:
8170: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
8171: p_procedure_name => 'INSERT_PUBLISHED_RECORD',
8172: p_error_text => SUBSTRB(SQLERRM,1,240));
8173: raise;
8174: END INSERT_PUBLISHED_RECORD;

Line 8229: FND_MSG_PUB.initialize;

8225: END IF;
8226:
8227:
8228: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
8229: FND_MSG_PUB.initialize;
8230: END IF;
8231:
8232:
8233: IF g1_debug_mode = 'Y' THEN

Line 8921: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

8917: x_msg_count := 1;
8918: x_msg_data := SQLERRM;
8919:
8920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8921: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
8922: p_procedure_name => 'INSERT_WORKING_RECORD',
8923: p_error_text => SUBSTRB(SQLERRM,1,240));
8924: when OTHERS then
8925: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 8929: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

8925: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
8926: x_msg_count := 1;
8927: x_msg_data := SUBSTRB(SQLERRM,1,240);
8928:
8929: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
8930: p_procedure_name => 'INSERT_WORKING_RECORD',
8931: p_error_text => SUBSTRB(SQLERRM,1,240));
8932: raise;
8933: END INSERT_WORKING_RECORD;

Line 9000: FND_MSG_PUB.initialize;

8996: END IF;
8997:
8998:
8999: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
9000: FND_MSG_PUB.initialize;
9001: END IF;
9002:
9003:
9004: IF g1_debug_mode = 'Y' THEN

Line 11535: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

11531: x_msg_count := 1;
11532: x_msg_data := SQLERRM;
11533:
11534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11535: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
11536: p_procedure_name => 'INSERT_UPD_WORKING_RECORDS',
11537: p_error_text => SUBSTRB(SQLERRM,1,240));
11538: when OTHERS then
11539: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 11543: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

11539: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
11540: x_msg_count := 1;
11541: x_msg_data := SUBSTRB(SQLERRM,1,240);
11542:
11543: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
11544: p_procedure_name => 'INSERT_UPD_WORKING_RECORDS',
11545: p_error_text => SUBSTRB(SQLERRM,1,240));
11546: raise;
11547: END INSERT_UPD_WORKING_RECORDS;

Line 11614: FND_MSG_PUB.initialize;

11610: END IF;
11611:
11612:
11613: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
11614: FND_MSG_PUB.initialize;
11615: END IF;
11616:
11617:
11618: IF g1_debug_mode = 'Y' THEN

Line 14056: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

14052: x_msg_count := 1;
14053: x_msg_data := SQLERRM;
14054:
14055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14056: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
14057: p_procedure_name => 'INSERT_UPD_PUBLISHED_RECORDS',
14058: p_error_text => SUBSTRB(SQLERRM,1,240));
14059: when OTHERS then
14060: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 14064: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

14060: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
14061: x_msg_count := 1;
14062: x_msg_data := SUBSTRB(SQLERRM,1,240);
14063:
14064: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
14065: p_procedure_name => 'INSERT_UPD_PUBLISHED_RECORDS',
14066: p_error_text => SUBSTRB(SQLERRM,1,240));
14067: raise;
14068: END INSERT_UPD_PUBLISHED_RECORDS;

Line 14119: FND_MSG_PUB.initialize;

14115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14116: END IF;
14117:
14118: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
14119: FND_MSG_PUB.initialize;
14120: END IF;
14121:
14122: x_return_status := FND_API.G_RET_STS_SUCCESS;
14123:

Line 14163: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

14159: x_return_status => l_return_status,
14160: x_msg_code => l_msg_data);
14161: EXCEPTION
14162: WHEN OTHERS THEN
14163: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
14164: p_procedure_name => 'POPULATE_PJI_TAB_FOR_PLAN_PRJ',
14165: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_UTILS.populate_updatewbs_data Failed. SQLERRM='||SQLERRM,1,120));
14166: RAISE FND_API.G_EXC_ERROR;
14167: END;

Line 14188: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

14184: if p_commit = FND_API.G_TRUE then
14185: rollback to plan_qtys;
14186: end if;
14187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14188: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
14189: p_procedure_name => 'populate_pji_tab_for_plan_prj',
14190: p_error_text => SUBSTRB(SQLERRM,1,120));
14191: when OTHERS then
14192: if p_commit = FND_API.G_TRUE then

Line 14196: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

14192: if p_commit = FND_API.G_TRUE then
14193: rollback to plan_qtys;
14194: end if;
14195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14196: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
14197: p_procedure_name => 'populate_pji_tab_for_plan_prj',
14198: p_error_text => SUBSTRB(SQLERRM,1,120));
14199: raise;
14200: end populate_pji_tab_for_plan_prj;