201:
202: BEGIN
203:
204:
205: -- Standard Start of API savepoint
206:
207: SAVEPOINT CREATE_DEBRIEF_HEADER_PVT;
208: -- Standard call to check for call compatibility.
209:
204:
205: -- Standard Start of API savepoint
206:
207: SAVEPOINT CREATE_DEBRIEF_HEADER_PVT;
208: -- Standard call to check for call compatibility.
209:
210: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
211: p_api_version_number,
212: l_api_name,
454: END IF;
455: END IF;
456:
457:
458: -- Standard check for p_commit
459: IF FND_API.to_Boolean( p_commit )
460: THEN
461: COMMIT WORK;
462: END IF;
461: COMMIT WORK;
462: END IF;
463:
464:
465: -- Standard call to get message count and if count is 1, get message info.
466: FND_MSG_PUB.Count_And_Get
467: ( p_count => x_msg_count,
468: p_data => x_msg_data
469: );
550: where jta.task_assignment_id = p_debrief_rec.TASK_ASSIGNMENT_ID;
551:
552: BEGIN
553:
554: -- Standard Start of API savepoint
555: SAVEPOINT UPDATE_DEBRIEF_PVT;
556: -- Standard call to check for call compatibility.
557:
558: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
552: BEGIN
553:
554: -- Standard Start of API savepoint
555: SAVEPOINT UPDATE_DEBRIEF_PVT;
556: -- Standard call to check for call compatibility.
557:
558: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
559: p_api_version_number,
560: l_api_name,
703: --
704: -- End of API body.
705: --
706:
707: -- Standard check for p_commit
708: IF FND_API.to_Boolean( p_commit )
709: THEN
710: COMMIT WORK;
711: END IF;
709: THEN
710: COMMIT WORK;
711: END IF;
712:
713: -- Standard call to get message count and if count is 1, get message info.
714: FND_MSG_PUB.Count_And_Get
715: ( p_count => x_msg_count,
716: p_data => x_msg_data
717: );
800: close c;
801: end if;
802: END IF;
803:
804: -- Standard call to get message count and if count is 1, get message info.
805: FND_MSG_PUB.Count_And_Get
806: ( p_count => x_msg_count,
807: p_data => x_msg_data
808: );
837: FND_MSG_PUB.ADD;
838: END IF;
839: END IF;
840:
841: -- Standard call to get message count and if count is 1, get message info.
842: FND_MSG_PUB.Count_And_Get
843: ( p_count => x_msg_count,
844: p_data => x_msg_data
845: );
1049: BEGIN
1050: --dbms_output.put_line('DBF PVT : BEGIN...');
1051: z_debrief_line_number := p_debrief_line_tbl(1).debrief_line_number ;
1052:
1053: -- Standard Start of API savepoint
1054:
1055: SAVEPOINT CREATE_DEBRIEF_LINE_PVT;
1056:
1057: -- Standard call to check for call compatibility.
1053: -- Standard Start of API savepoint
1054:
1055: SAVEPOINT CREATE_DEBRIEF_LINE_PVT;
1056:
1057: -- Standard call to check for call compatibility.
1058: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1059: p_api_version_number,
1060: l_api_name,
1061: G_PKG_NAME)
1740: FALSE,
1741: 1.0,
1742: p_debrief_line_rec.debrief_header_id);
1743: end if;
1744: -- Standard check for p_commit
1745: IF FND_API.to_Boolean( p_commit )
1746: THEN
1747: COMMIT WORK;
1748: END IF;
1748: END IF;
1749:
1750: END IF;
1751:
1752: -- Standard call to get message count and if count is 1, get message info.
1753: FND_MSG_PUB.Count_And_Get
1754: ( p_count => x_msg_count,
1755: p_data => x_msg_data
1756: );
1829: end if;
1830: close validate_ta_status ;
1831: END IF;
1832:
1833: -- Standard call to get message count and if count is 1, get message info.
1834: FND_MSG_PUB.Count_And_Get
1835: ( p_count => x_msg_count,
1836: p_data => x_msg_data
1837: );
1954: if p_debrief_line_rec.receiving_inventory_org_id = fnd_api.g_miss_num then
1955: l_receiving_inventory_org_id := null;
1956: end if;
1957:
1958: -- Standard Start of API savepoint
1959: SAVEPOINT UPDATE_DEBRIEF_LINE_PVT;
1960:
1961: -- Standard call to check for call compatibility.
1962: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1957:
1958: -- Standard Start of API savepoint
1959: SAVEPOINT UPDATE_DEBRIEF_LINE_PVT;
1960:
1961: -- Standard call to check for call compatibility.
1962: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1963: p_api_version_number,
1964: l_api_name,
1965: G_PKG_NAME)
2401: 1.0,
2402: p_debrief_line_rec.debrief_header_id);
2403: end if;
2404:
2405: -- Standard check for p_commit
2406: IF FND_API.to_Boolean( p_commit )
2407: THEN
2408: COMMIT WORK;
2409: END IF;
2415: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
2416: FND_MSG_PUB.Add;
2417: END IF;
2418:
2419: -- Standard call to get message count and if count is 1, get message info.
2420: FND_MSG_PUB.Count_And_Get
2421: ( p_count => x_msg_count,
2422: p_data => x_msg_data
2423: );
2478: FND_MSG_PUB.ADD;
2479: END IF;
2480: END IF;
2481:
2482: -- Standard call to get message count and if count is 1, get message info.
2483: FND_MSG_PUB.Count_And_Get
2484: ( p_count => x_msg_count,
2485: p_data => x_msg_data
2486: );
2529: FND_MSG_PUB.ADD;
2530: END IF;
2531: END IF;
2532:
2533: -- Standard call to get message count and if count is 1, get message info.
2534: FND_MSG_PUB.Count_And_Get
2535: ( p_count => x_msg_count,
2536: p_data => x_msg_data);
2537:
2572: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVENTORY_ITEM_ID');
2573: FND_MSG_PUB.ADD;
2574: END IF;
2575: END IF;
2576: -- Standard call to get message count and if count is 1, get message info.
2577: FND_MSG_PUB.Count_And_Get
2578: ( p_count => x_msg_count,
2579: p_data => x_msg_data
2580: );
2619: end if;
2620: close get_instance_id;
2621: END IF;
2622:
2623: -- Standard call to get message count and if count is 1, get message info.
2624: FND_MSG_PUB.Count_And_Get
2625: ( p_count => x_msg_count,
2626: p_data => x_msg_data
2627: );
2668: END IF;
2669: end if;
2670: close validate_header_id ;
2671: END IF;
2672: -- Standard call to get message count and if count is 1, get message info.
2673: FND_MSG_PUB.Count_And_Get
2674: ( p_count => x_msg_count,
2675: p_data => x_msg_data
2676: );
2708: FND_MSG_PUB.ADD;
2709: END IF;
2710: END IF;
2711:
2712: -- Standard call to get message count and if count is 1, get message info.
2713: FND_MSG_PUB.Count_And_Get
2714: ( p_count => x_msg_count,
2715: p_data => x_msg_data
2716: );
2758: end if;
2759: close get_business_process_id;
2760: END IF;
2761:
2762: -- Standard call to get message count and if count is 1, get message info.
2763: FND_MSG_PUB.Count_And_Get
2764: ( p_count => x_msg_count,
2765: p_data => x_msg_data
2766: );
2806: end if;
2807: close get_transaction_type_id;
2808: END IF;
2809:
2810: -- Standard call to get message count and if count is 1, get message info.
2811: FND_MSG_PUB.Count_And_Get
2812: ( p_count => x_msg_count,
2813: p_data => x_msg_data
2814: );
2840: l_interaction_id number;
2841: l_activity_id number;
2842: l_msg_index_out number;
2843: Begin
2844: -- Standard Start of API savepoint
2845: SAVEPOINT CREATE_INTERACTION;
2846: -- Standard call to check for call compatibility.
2847:
2848: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2842: l_msg_index_out number;
2843: Begin
2844: -- Standard Start of API savepoint
2845: SAVEPOINT CREATE_INTERACTION;
2846: -- Standard call to check for call compatibility.
2847:
2848: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2849: p_api_version_number,
2850: l_api_name,
3715: x_return_status := FND_API.G_RET_STS_ERROR;
3716: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_PENDING');
3717: FND_MSG_PUB.ADD;
3718: end if;
3719: -- Standard call to get message count and if count is 1, get message info.
3720: FND_MSG_PUB.Count_And_Get
3721: ( p_count => x_msg_count,
3722: p_data => x_msg_data);
3723: END CLOSE_DEBRIEF;