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 5137: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',

5133: x_msg_count := 1;
5134: x_msg_data := SQLERRM;
5135:
5136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5137: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
5138: p_procedure_name => 'INSERT_PUBLISHED_RECORDS',
5139: p_error_text => SUBSTRB(SQLERRM,1,240));
5140: when OTHERS then
5141: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

5141: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5142: x_msg_count := 1;
5143: x_msg_data := SUBSTRB(SQLERRM,1,240);
5144:
5145: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
5146: p_procedure_name => 'INSERT_PUBLISHED_RECORDS',
5147: p_error_text => SUBSTRB(SQLERRM,1,240));
5148: raise;
5149: END INSERT_PUBLISHED_RECORDS;

Line 5211: FND_MSG_PUB.initialize;

5207: END IF;
5208:
5209:
5210: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
5211: FND_MSG_PUB.initialize;
5212: END IF;
5213:
5214:
5215: IF g1_debug_mode = 'Y' THEN

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

7742: x_msg_count := 1;
7743: x_msg_data := SQLERRM;
7744:
7745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7746: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
7747: p_procedure_name => 'INSERT_WORKING_RECORDS',
7748: p_error_text => SUBSTRB(SQLERRM,1,240));
7749: when OTHERS then
7750: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

7750: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7751: x_msg_count := 1;
7752: x_msg_data := SUBSTRB(SQLERRM,1,240);
7753:
7754: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
7755: p_procedure_name => 'INSERT_WORKING_RECORDS',
7756: p_error_text => SUBSTRB(SQLERRM,1,240));
7757: raise;
7758: END INSERT_WORKING_RECORDS;

Line 7853: FND_MSG_PUB.initialize;

7849: END IF;
7850:
7851:
7852: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
7853: FND_MSG_PUB.initialize;
7854: END IF;
7855:
7856:
7857: IF g1_debug_mode = 'Y' THEN

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

9724: x_msg_count := 1;
9725: x_msg_data := SQLERRM;
9726:
9727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9728: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
9729: p_procedure_name => 'INSERT_SUBPROJECTS',
9730: p_error_text => SUBSTRB(SQLERRM,1,240));
9731: when OTHERS then
9732: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

9732: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
9733: x_msg_count := 1;
9734: x_msg_data := SUBSTRB(SQLERRM,1,240);
9735:
9736: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
9737: p_procedure_name => 'INSERT_SUBPROJECTS',
9738: p_error_text => SUBSTRB(SQLERRM,1,240));
9739: raise;
9740: END INSERT_SUBPROJECTS;

Line 9799: FND_MSG_PUB.initialize;

9795: END IF;
9796:
9797:
9798: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
9799: FND_MSG_PUB.initialize;
9800: END IF;
9801:
9802:
9803: IF g1_debug_mode = 'Y' THEN

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

10488: x_msg_count := 1;
10489: x_msg_data := SQLERRM;
10490:
10491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10492: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
10493: p_procedure_name => 'INSERT_PUBLISHED_RECORD',
10494: p_error_text => SUBSTRB(SQLERRM,1,240));
10495: when OTHERS then
10496: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

10496: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
10497: x_msg_count := 1;
10498: x_msg_data := SUBSTRB(SQLERRM,1,240);
10499:
10500: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
10501: p_procedure_name => 'INSERT_PUBLISHED_RECORD',
10502: p_error_text => SUBSTRB(SQLERRM,1,240));
10503: raise;
10504: END INSERT_PUBLISHED_RECORD;

Line 10559: FND_MSG_PUB.initialize;

10555: END IF;
10556:
10557:
10558: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
10559: FND_MSG_PUB.initialize;
10560: END IF;
10561:
10562:
10563: IF g1_debug_mode = 'Y' THEN

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

11247: x_msg_count := 1;
11248: x_msg_data := SQLERRM;
11249:
11250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11251: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
11252: p_procedure_name => 'INSERT_WORKING_RECORD',
11253: p_error_text => SUBSTRB(SQLERRM,1,240));
11254: when OTHERS then
11255: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

11255: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
11256: x_msg_count := 1;
11257: x_msg_data := SUBSTRB(SQLERRM,1,240);
11258:
11259: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
11260: p_procedure_name => 'INSERT_WORKING_RECORD',
11261: p_error_text => SUBSTRB(SQLERRM,1,240));
11262: raise;
11263: END INSERT_WORKING_RECORD;

Line 11330: FND_MSG_PUB.initialize;

11326: END IF;
11327:
11328:
11329: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
11330: FND_MSG_PUB.initialize;
11331: END IF;
11332:
11333:
11334: IF g1_debug_mode = 'Y' THEN

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

13864: x_msg_count := 1;
13865: x_msg_data := SQLERRM;
13866:
13867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13868: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
13869: p_procedure_name => 'INSERT_UPD_WORKING_RECORDS',
13870: p_error_text => SUBSTRB(SQLERRM,1,240));
13871: when OTHERS then
13872: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

13872: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
13873: x_msg_count := 1;
13874: x_msg_data := SUBSTRB(SQLERRM,1,240);
13875:
13876: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
13877: p_procedure_name => 'INSERT_UPD_WORKING_RECORDS',
13878: p_error_text => SUBSTRB(SQLERRM,1,240));
13879: raise;
13880: END INSERT_UPD_WORKING_RECORDS;

Line 13947: FND_MSG_PUB.initialize;

13943: END IF;
13944:
13945:
13946: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
13947: FND_MSG_PUB.initialize;
13948: END IF;
13949:
13950:
13951: IF g1_debug_mode = 'Y' THEN

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

16388: x_msg_count := 1;
16389: x_msg_data := SQLERRM;
16390:
16391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16392: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
16393: p_procedure_name => 'INSERT_UPD_PUBLISHED_RECORDS',
16394: p_error_text => SUBSTRB(SQLERRM,1,240));
16395: when OTHERS then
16396: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

16396: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
16397: x_msg_count := 1;
16398: x_msg_data := SUBSTRB(SQLERRM,1,240);
16399:
16400: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
16401: p_procedure_name => 'INSERT_UPD_PUBLISHED_RECORDS',
16402: p_error_text => SUBSTRB(SQLERRM,1,240));
16403: raise;
16404: END INSERT_UPD_PUBLISHED_RECORDS;

Line 16455: FND_MSG_PUB.initialize;

16451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16452: END IF;
16453:
16454: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
16455: FND_MSG_PUB.initialize;
16456: END IF;
16457:
16458: x_return_status := FND_API.G_RET_STS_SUCCESS;
16459:

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

16495: x_return_status => l_return_status,
16496: x_msg_code => l_msg_data);
16497: EXCEPTION
16498: WHEN OTHERS THEN
16499: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
16500: p_procedure_name => 'POPULATE_PJI_TAB_FOR_PLAN_PRJ',
16501: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_UTILS.populate_updatewbs_data Failed. SQLERRM='||SQLERRM,1,120));
16502: RAISE FND_API.G_EXC_ERROR;
16503: END;

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

16520: if p_commit = FND_API.G_TRUE then
16521: rollback to plan_qtys;
16522: end if;
16523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16524: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
16525: p_procedure_name => 'populate_pji_tab_for_plan_prj',
16526: p_error_text => SUBSTRB(SQLERRM,1,120));
16527: when OTHERS then
16528: if p_commit = FND_API.G_TRUE then

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

16528: if p_commit = FND_API.G_TRUE then
16529: rollback to plan_qtys;
16530: end if;
16531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16532: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_STRUCTURE_PUB',
16533: p_procedure_name => 'populate_pji_tab_for_plan_prj',
16534: p_error_text => SUBSTRB(SQLERRM,1,120));
16535: raise;
16536: end populate_pji_tab_for_plan_prj;