eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PC_HEADER_PVT dependencies on FND_MSG_PUB

Line 134: FND_MSG_PUB.Initialize;

130:
131: -- Initialize message list if p_init_msg_list is set to TRUE
132: IF FND_API.To_Boolean(p_init_msg_list)
133: THEN
134: FND_MSG_PUB.Initialize;
135: END IF;
136:
137: x_return_status := FND_API.G_RET_STS_SUCCESS;
138:

Line 151: x_msg_count := FND_MSG_PUB.count_msg;

147:
148: VALIDATE_PC_HEADER(p_x_pc_header_rec);
149:
150: -- Check Error Message stack.
151: x_msg_count := FND_MSG_PUB.count_msg;
152: IF x_msg_count > 0
153: THEN
154: RAISE FND_API.G_EXC_ERROR;
155: END IF;

Line 210: x_msg_count := FND_MSG_PUB.count_msg;

206: AHL_DEBUG_PUB.debug('PCH -- PVT -- Created Header for ID='||p_x_pc_header_rec.PC_HEADER_ID);
207: END IF;
208:
209: -- Check Error Message stack.
210: x_msg_count := FND_MSG_PUB.count_msg;
211: IF x_msg_count > 0
212: THEN
213: RAISE FND_API.G_EXC_ERROR;
214: END IF;

Line 223: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

219: COMMIT WORK;
220: END IF;
221:
222: -- Standard call to get message count and if count is 1, get message info
223: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
224: p_data => x_msg_data,
225: p_encoded => fnd_api.g_false );
226:
227: EXCEPTION

Line 231: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

227: EXCEPTION
228: WHEN FND_API.G_EXC_ERROR THEN
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: Rollback to CREATE_PC_HEADER_PVT;
231: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
232: p_data => x_msg_data,
233: p_encoded => fnd_api.g_false);
234:
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 238: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

234:
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: Rollback to CREATE_PC_HEADER_PVT;
238: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
239: p_data => x_msg_data,
240: p_encoded => fnd_api.g_false);
241:
242: WHEN OTHERS THEN

Line 245: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

241:
242: WHEN OTHERS THEN
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244: Rollback to CREATE_PC_HEADER_PVT;
245: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
246: THEN
247: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
248: p_procedure_name => 'CREATE_PC_HEADER',
249: p_error_text => SUBSTR(SQLERRM,1,240));

Line 247: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244: Rollback to CREATE_PC_HEADER_PVT;
245: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
246: THEN
247: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
248: p_procedure_name => 'CREATE_PC_HEADER',
249: p_error_text => SUBSTR(SQLERRM,1,240));
250: END IF;
251: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 251: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

247: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
248: p_procedure_name => 'CREATE_PC_HEADER',
249: p_error_text => SUBSTR(SQLERRM,1,240));
250: END IF;
251: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
252: p_data => x_msg_data,
253: p_encoded => fnd_api.g_false);
254:
255: END CREATE_PC_HEADER;

Line 303: FND_MSG_PUB.Initialize;

299:
300: -- Initialize message list if p_init_msg_list is set to TRUE
301: IF FND_API.To_Boolean(p_init_msg_list)
302: THEN
303: FND_MSG_PUB.Initialize;
304: END IF;
305:
306: x_return_status := FND_API.G_RET_STS_SUCCESS;
307:

Line 327: FND_MSG_PUB.ADD;

323: l_is_dup_assos := GET_DUP_UNIT_ITEM_ASSOS (p_x_pc_header_rec.pc_header_id);
324: IF (l_is_dup_assos)
325: THEN
326: FND_MESSAGE.Set_Name('AHL','AHL_PC_DUP_UNIT_PART_ASSOS');
327: FND_MSG_PUB.ADD;
328: RAISE FND_API.G_EXC_ERROR;
329: END IF;
330: END IF;
331: END IF;

Line 364: x_msg_count := FND_MSG_PUB.count_msg;

360:
361: IF p_x_pc_header_rec.OPERATION_FLAG = AHL_PC_HEADER_PVT.G_DML_LINK
362: THEN
363: -- Check Error Message stack.
364: x_msg_count := FND_MSG_PUB.count_msg;
365: IF x_msg_count > 0
366: THEN
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;

Line 377: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

373: COMMIT WORK;
374: END IF;
375:
376: -- Standard call to get message count and if count is 1, get message info
377: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
378: p_data => x_msg_data,
379: p_encoded => fnd_api.g_false );
380:
381: RETURN;

Line 388: x_msg_count := FND_MSG_PUB.count_msg;

384: END IF;
385: END IF;
386:
387: -- Check Error Message stack.
388: x_msg_count := FND_MSG_PUB.count_msg;
389: IF x_msg_count > 0
390: THEN
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;

Line 433: x_msg_count := FND_MSG_PUB.count_msg;

429: AHL_DEBUG_PUB.debug('PCH -- PVT -- UPDATE_PC_HEADER -- After DB Update');
430: END IF;
431:
432: -- Check Error Message stack.
433: x_msg_count := FND_MSG_PUB.count_msg;
434: IF x_msg_count > 0
435: THEN
436: RAISE FND_API.G_EXC_ERROR;
437: END IF;

Line 446: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

442: COMMIT WORK;
443: END IF;
444:
445: -- Standard call to get message count and if count is 1, get message info
446: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
447: p_data => x_msg_data,
448: p_encoded => fnd_api.g_false );
449:
450: EXCEPTION

Line 454: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

450: EXCEPTION
451: WHEN FND_API.G_EXC_ERROR THEN
452: x_return_status := FND_API.G_RET_STS_ERROR;
453: Rollback to UPDATE_PC_HEADER_PVT;
454: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
455: p_data => x_msg_data,
456: p_encoded => fnd_api.g_false );
457:
458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 461: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

457:
458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
460: Rollback to UPDATE_PC_HEADER_PVT;
461: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
462: p_data => x_msg_data,
463: p_encoded => fnd_api.g_false );
464:
465: WHEN OTHERS THEN

Line 468: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

464:
465: WHEN OTHERS THEN
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
467: Rollback to UPDATE_PC_HEADER_PVT;
468: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
469: THEN
470: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
471: p_procedure_name => 'UPDATE_PC_HEADER',
472: p_error_text => SUBSTR(SQLERRM,1,240) );

Line 470: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
467: Rollback to UPDATE_PC_HEADER_PVT;
468: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
469: THEN
470: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
471: p_procedure_name => 'UPDATE_PC_HEADER',
472: p_error_text => SUBSTR(SQLERRM,1,240) );
473: END IF;
474: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 474: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

470: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
471: p_procedure_name => 'UPDATE_PC_HEADER',
472: p_error_text => SUBSTR(SQLERRM,1,240) );
473: END IF;
474: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
475: p_data => x_msg_data,
476: p_encoded => fnd_api.g_false );
477:
478: END UPDATE_PC_HEADER;

Line 542: FND_MSG_PUB.Initialize;

538:
539: -- Initialize message list if p_init_msg_list is set to TRUE
540: IF FND_API.To_Boolean(p_init_msg_list)
541: THEN
542: FND_MSG_PUB.Initialize;
543: END IF;
544:
545: x_return_status := FND_API.G_RET_STS_SUCCESS;
546:

Line 556: FND_MSG_PUB.ADD;

552: FETCH check_header_status INTO l_status;
553: IF(check_header_status%NOTFOUND)
554: THEN
555: FND_MESSAGE.Set_Name('AHL','AHL_PC_NOT_FOUND');
556: FND_MSG_PUB.ADD;
557: CLOSE check_header_status;
558: RAISE FND_API.G_EXC_ERROR;
559: ELSE
560: CLOSE check_header_status;

Line 564: FND_MSG_PUB.ADD;

560: CLOSE check_header_status;
561: IF (l_status <> 'DRAFT' AND l_status <> 'APPROVAL_REJECTED')
562: THEN
563: FND_MESSAGE.SET_NAME('AHL','AHL_PC_DRAFT_DELETE');
564: FND_MSG_PUB.ADD;
565: RAISE FND_API.G_EXC_ERROR;
566: ELSE
567:
568: l_link_to_header_id := 0;

Line 603: x_msg_count := FND_MSG_PUB.count_msg;

599: -- Added error handling after the Delete_Nodes API is called.
600: -- Check Error Message stack.
601: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
602: THEN
603: x_msg_count := FND_MSG_PUB.count_msg;
604: IF x_msg_count > 0 THEN
605: RAISE FND_API.G_EXC_ERROR;
606: END IF;
607: END IF;

Line 688: x_msg_count := FND_MSG_PUB.count_msg;

684: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_HEADER -- After DB Delete');
685: END IF;
686:
687: -- Check Error Message stack.
688: x_msg_count := FND_MSG_PUB.count_msg;
689: IF x_msg_count > 0
690: THEN
691: RAISE FND_API.G_EXC_ERROR;
692: END IF;

Line 701: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

697: COMMIT WORK;
698: END IF;
699:
700: -- Standard call to get message count and if count is 1, get message info
701: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
702: p_data => x_msg_data,
703: p_encoded => fnd_api.g_false );
704:
705: EXCEPTION

Line 709: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

705: EXCEPTION
706: WHEN FND_API.G_EXC_ERROR THEN
707: x_return_status := FND_API.G_RET_STS_ERROR;
708: Rollback to DELETE_PC_HEADER_PVT;
709: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
710: p_data => x_msg_data,
711: p_encoded => fnd_api.g_false );
712:
713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 716: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

712:
713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
715: Rollback to DELETE_PC_HEADER_PVT;
716: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
717: p_data => x_msg_data,
718: p_encoded => fnd_api.g_false );
719:
720: WHEN OTHERS THEN

Line 723: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

719:
720: WHEN OTHERS THEN
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722: Rollback to DELETE_PC_HEADER_PVT;
723: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
724: THEN
725: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
726: p_procedure_name => 'DELETE_PC_HEADER',
727: p_error_text => SUBSTR(SQLERRM,1,240) );

Line 725: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722: Rollback to DELETE_PC_HEADER_PVT;
723: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
724: THEN
725: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
726: p_procedure_name => 'DELETE_PC_HEADER',
727: p_error_text => SUBSTR(SQLERRM,1,240) );
728: END IF;
729: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 729: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

725: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
726: p_procedure_name => 'DELETE_PC_HEADER',
727: p_error_text => SUBSTR(SQLERRM,1,240) );
728: END IF;
729: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
730: p_data => x_msg_data,
731: p_encoded => fnd_api.g_false );
732: END DELETE_PC_HEADER;
733:

Line 920: FND_MSG_PUB.Initialize;

916:
917: -- Initialize message list if p_init_msg_list is set to TRUE
918: IF FND_API.To_Boolean(p_init_msg_list)
919: THEN
920: FND_MSG_PUB.Initialize;
921: END IF;
922:
923: x_return_status := FND_API.G_RET_STS_SUCCESS;
924:

Line 938: FND_MSG_PUB.ADD;

934: FETCH check_name_unique INTO l_dummy_2;
935: IF (check_name_unique%FOUND)
936: THEN
937: FND_MESSAGE.Set_Name('AHL','AHL_PC_NAME_EXISTS');
938: FND_MSG_PUB.ADD;
939: CLOSE check_name_unique;
940: RAISE FND_API.G_EXC_ERROR;
941: END IF;
942: CLOSE check_name_unique;

Line 958: FND_MSG_PUB.ADD;

954: l_is_dup_assos := GET_DUP_UNIT_ITEM_ASSOS (l_old_header_id);
955: IF (l_is_dup_assos)
956: THEN
957: FND_MESSAGE.Set_Name('AHL','AHL_PC_DUP_UNIT_PART_ASSOS');
958: FND_MSG_PUB.ADD;
959: RAISE FND_API.G_EXC_ERROR;
960: END IF;
961: END IF;
962: END IF;

Line 969: FND_MSG_PUB.ADD;

965:
966: IF (l_dummy = FALSE AND p_x_pc_header_rec.COPY_ASSOS_FLAG = 'Y')
967: THEN
968: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_PART_ATTACHED');
969: FND_MSG_PUB.ADD;
970: RAISE FND_API.G_EXC_ERROR;
971: END IF;
972:
973: CREATE_PC_HEADER

Line 988: x_msg_count := FND_MSG_PUB.count_msg;

984: IF G_DEBUG='Y' THEN
985: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- Copied into new PC with ID='||p_x_pc_header_rec.PC_HEADER_ID);
986: END IF;
987:
988: x_msg_count := FND_MSG_PUB.count_msg;
989: IF x_msg_count > 0
990: THEN
991: RAISE FND_API.G_EXC_ERROR;
992: END IF;

Line 1201: x_msg_count := FND_MSG_PUB.count_msg;

1197: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- After Copy PC');
1198: END IF;
1199:
1200: -- Check Error Message stack.
1201: x_msg_count := FND_MSG_PUB.count_msg;
1202: IF x_msg_count > 0
1203: THEN
1204: RAISE FND_API.G_EXC_ERROR;
1205: END IF;

Line 1214: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1210: COMMIT WORK;
1211: END IF;
1212:
1213: -- Standard call to get message count and if count is 1, get message info
1214: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1215: p_data => x_msg_data,
1216: p_encoded => fnd_api.g_false );
1217:
1218: EXCEPTION

Line 1222: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1218: EXCEPTION
1219: WHEN FND_API.G_EXC_ERROR THEN
1220: x_return_status := FND_API.G_RET_STS_ERROR;
1221: Rollback to COPY_PC_HEADER_PVT;
1222: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1223: p_data => x_msg_data,
1224: p_encoded => fnd_api.g_false );
1225:
1226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1229: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1225:
1226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1228: Rollback to COPY_PC_HEADER_PVT;
1229: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1230: p_data => x_msg_data,
1231: p_encoded => fnd_api.g_false );
1232:
1233: WHEN OTHERS THEN

Line 1236: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1232:
1233: WHEN OTHERS THEN
1234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1235: Rollback to COPY_PC_HEADER_PVT;
1236: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1237: THEN
1238: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1239: p_procedure_name => 'COPY_PC_HEADER',
1240: p_error_text => SUBSTR(SQLERRM,1,240) );

Line 1238: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

1234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1235: Rollback to COPY_PC_HEADER_PVT;
1236: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1237: THEN
1238: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1239: p_procedure_name => 'COPY_PC_HEADER',
1240: p_error_text => SUBSTR(SQLERRM,1,240) );
1241: END IF;
1242: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1242: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1238: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1239: p_procedure_name => 'COPY_PC_HEADER',
1240: p_error_text => SUBSTR(SQLERRM,1,240) );
1241: END IF;
1242: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1243: p_data => x_msg_data,
1244: p_encoded => fnd_api.g_false );
1245:
1246: END COPY_PC_HEADER;

Line 1291: FND_MSG_PUB.Initialize;

1287:
1288: -- Initialize message list if p_init_msg_list is set to TRUE
1289: IF FND_API.To_Boolean(p_init_msg_list)
1290: THEN
1291: FND_MSG_PUB.Initialize;
1292: END IF;
1293:
1294: x_return_status := FND_API.G_RET_STS_SUCCESS;
1295:

Line 1344: FND_MSG_PUB.ADD;

1340: -- If no updation happened, record must have already been modified by another user...
1341: IF (sql%rowcount) = 0
1342: THEN
1343: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1344: FND_MSG_PUB.ADD;
1345: RAISE FND_API.G_EXC_ERROR;
1346: -- Else start PCWF workflow process for this PC
1347: ELSE
1348: IF G_DEBUG='Y' THEN

Line 1476: FND_MSG_PUB.ADD;

1472: FETCH check_name into l_dummy;
1473: IF (check_name%FOUND)
1474: THEN
1475: FND_MESSAGE.Set_Name('AHL','AHL_PC_NAME_EXISTS');
1476: FND_MSG_PUB.ADD;
1477: CLOSE check_name;
1478: RAISE FND_API.G_EXC_ERROR;
1479: END IF;
1480: CLOSE check_name;

Line 1492: FND_MSG_PUB.ADD;

1488: FETCH check_prod_type into l_dummy;
1489: IF (check_prod_type%FOUND)
1490: THEN
1491: FND_MESSAGE.Set_Name('AHL','AHL_PC_PROD_PRIM_EXISTS');
1492: FND_MSG_PUB.ADD;
1493: CLOSE check_prod_type;
1494: RAISE FND_API.G_EXC_ERROR;
1495: END IF;
1496: CLOSE check_prod_type;

Line 1755: FND_MSG_PUB.Initialize;

1751:
1752: -- Initialize message list if p_init_msg_list is set to TRUE
1753: IF FND_API.To_Boolean(p_init_msg_list)
1754: THEN
1755: FND_MSG_PUB.Initialize;
1756: END IF;
1757:
1758: x_return_status := FND_API.G_RET_STS_SUCCESS;
1759:

Line 1794: x_msg_count := FND_MSG_PUB.count_msg;

1790: IF G_DEBUG='Y' THEN
1791: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- New Header ID='||p_x_pc_header_rec.PC_HEADER_ID);
1792: END IF;
1793:
1794: x_msg_count := FND_MSG_PUB.count_msg;
1795: IF x_msg_count > 0
1796: THEN
1797: RAISE FND_API.G_EXC_ERROR;
1798: END IF;

Line 1918: x_msg_count := FND_MSG_PUB.count_msg;

1914: l_nodeId_tbl(l_nodeCtr).NODE_ID := l_node_data_rec.PC_NODE_ID;
1915: l_nodeId_tbl(l_nodeCtr).NEW_NODE_ID := l_node_rec.PC_NODE_ID;
1916: l_nodeCtr := l_nodeCtr + 1;
1917:
1918: x_msg_count := FND_MSG_PUB.count_msg;
1919: IF x_msg_count > 0
1920: THEN
1921: RAISE FND_API.G_EXC_ERROR;
1922: END IF;

Line 2604: FND_MSG_PUB.Initialize;

2600:
2601: -- Initialize message list if p_init_msg_list is set to TRUE
2602: IF FND_API.To_Boolean(p_init_msg_list)
2603: THEN
2604: FND_MSG_PUB.Initialize;
2605: END IF;
2606:
2607: x_return_status := FND_API.G_RET_STS_SUCCESS;
2608:

Line 3408: FND_MSG_PUB.Initialize;

3404: BEGIN
3405: -- Initialize message list if p_init_msg_list is set to TRUE
3406: IF FND_API.To_Boolean(p_init_msg_list)
3407: THEN
3408: FND_MSG_PUB.Initialize;
3409: END IF;
3410:
3411: x_return_status := FND_API.G_RET_STS_SUCCESS;
3412:

Line 3427: FND_MSG_PUB.ADD;

3423: l_old_assos_type,p_x_pc_header_rec.link_to_pc_id;
3424: IF (check_header_data%NOTFOUND)
3425: THEN
3426: FND_MESSAGE.Set_Name('AHL','AHL_PC_NOT_FOUND');
3427: FND_MSG_PUB.ADD;
3428: CLOSE check_header_data;
3429: RAISE FND_API.G_EXC_ERROR;
3430: END IF;
3431: CLOSE check_header_data;

Line 3436: FND_MSG_PUB.ADD;

3432:
3433: IF l_old_obj_ver_no <> p_x_pc_header_rec.OBJECT_VERSION_NUMBER
3434: THEN
3435: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
3436: FND_MSG_PUB.ADD;
3437: RAISE FND_API.G_EXC_ERROR;
3438: END IF;
3439:
3440: l_dummy := VALIDATE_UNIT_PART_ATTACHED (p_x_pc_header_rec.PC_HEADER_ID, p_x_pc_header_rec.PRODUCT_TYPE_CODE, p_x_pc_header_rec.ASSOCIATION_TYPE_FLAG);

Line 3445: FND_MSG_PUB.ADD;

3441:
3442: IF (l_dummy = FALSE)
3443: THEN
3444: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_PART_ATTACHED');
3445: FND_MSG_PUB.ADD;
3446: RAISE FND_API.G_EXC_ERROR;
3447: END IF;
3448:
3449: IF G_DEBUG='Y' THEN

Line 3457: FND_MSG_PUB.ADD;

3453: -- PC is COMPLETE -- User submits without changing to DRAFT -- ERROR
3454: IF p_x_pc_header_rec.STATUS = 'COMPLETE' AND l_old_status = 'COMPLETE'
3455: THEN
3456: FND_MESSAGE.Set_Name('AHL','AHL_PC_STATUS_COMPLETE');
3457: FND_MSG_PUB.ADD;
3458: RAISE FND_API.G_EXC_ERROR;
3459:
3460: -- PC is APPROVAL_REJECTED -- User submits after making any change -- Change status to DRAFT
3461: ELSIF p_x_pc_header_rec.STATUS = 'APPROVAL_REJECTED' AND l_old_status = 'APPROVAL_REJECTED'